Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a date in the format of YYYYMMDD, i need to create 2 variables, one with the max date (easy), and the next with the day before, i cannot simply calculate it because the 1st will always end up with zero's, eg: 20160201 would be present day and 20160200 would end up as previous day.
so in my mind convert the number to a date and then do the calculation but there is no date add functionality (similar to month add)
anyone please assist.
Regards
LOAD
Date#( DateField, 'YYYYMMDD') as DateField
FROM ....;
Now you can just write
=Date( Max( DateField),'YYYYMMDD')
resp.
=Date( Max( DateField)-1 ,'YYYYMMDD')