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.

[christine_assaad · Accepted solution]

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

[Qiu · Accepted solution]

@Data_Alter 
Sometimes just a small things get we stuck.😁