
Creator II
2022-11-01
04:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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..
454 Views
1 Reply


Specialist II
2022-11-01
05:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this to force the variable to be interpreted as a date: MonthEnd(Date#('$(vDate)', 'YYYYMMDD'), -1)
