Conditional if formatting

[Dharma_A]

I have 2 conditions:

Condition 1: month column contains Current month and previous month.

Condition 2: month column doesn't contain Either of the month.

Where, when condition 1 satisfies then condition 2 should not run and when condition 1 doesn't satisfy then condition 2 should work.

[dwstada]

@Dharma_A here's the formula for that:

if
DateTimeTrim([month column],"month") = DateTimeTrim(DateTimeToday(),"month") OR
DateTimeTrim([month column],"month") = DateTimeAdd(DateTimeTrim(DateTimeToday(),"month"),-1,"month")
then [condition 1]
else [condition 2]
endif

[nbondarchuk · Accepted solution]

It works for me. Could you please clarify your concern?