Date time trim doesn't work

Data_Alter

In my workflow below I want that

if the date in "Aim end" column is last day of the month then it should stay as that but if the date is any other day of month then it should get converted to first day of the month.

My formula is converting it to first day always.

Please can someone suggest the correction in formula.

Date time trim.yxmd

Christine_Assaad

Hi @Data_Alter 

I just removed the time from your todatetime formula (since the initial Aim end does not include time) to be as following :

if

todate(DateTimeTrim([Aim end],"lastofmonth")) = [Aim end]

then

[Aim end]

else

DateTimeTrim([Aim end],"firstofmonth")

endif