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.
Solved! Go to 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
@Data_Alter
Sometimes just a small things get we stuck.😁