Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
raadwiptec
Creator II
Creator II

MonthEnd

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..

 

 

 

Labels (1)
1 Reply
henrikalmen
Specialist II
Specialist II

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