Can anyone tell me how I can convert a transactional date to always the first day of that particular month?
The real date formation that I'm currently loading in QV is YYYYMMDD (e.g. 20150528)
This is in the load script converted to DDMMYY (28052015) by means of the below but now I want the system to make a new date so that it will read 01052015
(makedate(left(Trim([Invoice Date]),4),mid(trim([Invoice Date]),5,2), right(Trim([Invoice Date]),2))) as Date
Any suggestions are welcome.
another solution could be:
Date(MonthStart(Date),'DDMMYY') as MonthStart;
LOAD Date(Date#([Invoice Date], 'YYYYMMDD'),'DDMMYY') as Date
hope this helps