Conditional Formula for Dates/Month

[AjaySetty]

Experts,

Need help with conditional formula where I have column with set of dates ranging from different months.

(in parallel column) Results I need is - if date is related to current month then A otherwise B.

Example:

Date	Conditional result
18-05-20	B
20-06-20	B
19-07-20	B
20-05-20	B
05-08-20	B
05-09-20	A
09-09-20	A

[Emil_Kos]

Hi @AjaySetty,

I am really proud of myself as I believe my solution is quite elegant. 

Hope it helps!

[grazitti_sapna]

Hi @AjaySetty ,try this.

Thanks.

[wdavis]

Hi @AjaySetty 

This can be done by referencing the date today (DateTimeToday) and then using the DateTimeFormat expression within the Formula Tool. By specifying that it is the month you are looking for, you can then build your IF statement around this logic.

Let me know if this works for you!

Will

[AjaySetty]

Thanks both @Emil_Kos & @grazitti_sapna, both your solutions were great and worked but with a small issue.

If i have any date from previous year it considers as current and giving me A as result wherein it should be B.

[wdavis · Accepted solution]

Hi @AjaySetty 

I have updated the formulas in the workflow so that it is now comparing both the month and year to give the result of either A or B.

Let me know if this works for you.

Kind Regards,

Will

[AjaySetty]

@wdavis This worked well, Thank you 🙂