Change Month if Date over than 25/02/2020

[Pongsakon_J]

Hi,

Can Someone tell me that how to change or create field that if Date in column over 25/02/2020 show in March 2020

For e.g. now I used expression in 'if(date([POST DATE]>'25',Month[POST DATE]+1,Month{POST Date]'

Thank you,

[tresesco]

Try like:

if(day([POST DATE])>25, Month([POST DATE])+1, Month([POST Date])) as MonthNew

[Pongsakon_J]

Thank You, Sir

[Pongsakon_J]

I already using your expression,

the expression is active on Jan2020 and Feb2020 but in Dec2020 is inactive.

[sunny_talwar]

How about this

If(Day([POST DATE]) > 25,
  MonthStart([POST DATE], 1), 
  MonthStart([POST Date])
) as MonthNew