V_String to date

marcin2x4

I want to extract last day of month from below v_string date:

05/02/2018 00:01:00

I've managed to get it formatted to desired date format

datetimeformat(DatetimeParse([Date],"%d/%m/%Y"),"%d/%m/%Y")

How to get last day of the month now? 

This code returns error:

DateTimeLastOfMonth(datetimeformat(DatetimeParse([Date],"%d/%m/%Y"),"%d/%m/%Y"))

"Wrong number of parameters"

neilgallen

@marcin2x4 The little used "datetimetrim" function will trim dates to either 'firstofmonth' or 'lastofmonth' as below:

datetimeformat(datetimetrim(DatetimeParse([Date],"%d/%m/%Y"),'lastofmonth'),"%d/%m/%Y")