MonthEnd

[raadwiptec]

Iam trying to add in the where condition -- The monthend in the date format YYYYMMDD ( 20221031).. 

For Ex: Where Transaction_date > Monthend($(vDate), -1) . Where vDate is the user input from a text file controlled by the user outside.. The user inputs the date in format YYYYMMDD . 

The above does not give the correct results ,, the output looks very strange date output like 05/10/555906 etc..

[henrikalmen]

Try this to force the variable to be interpreted as a date: MonthEnd(Date#('$(vDate)', 'YYYYMMDD'), -1)