Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Simple question I'm sure but I just can't think of the answer! I have a spreadsheet but it doesn't contain DATE. I really need to have Date in the data so how do i add a field in the script for date. The date would need to be Todays date - 8.
Thanks
date(today(),'Specify format ')-8 as NewDate
Like this may be:
LOAD *,
Date(Today() - 😎 as Date
FROM Source;
UPDATE: Please note that this will keep on updating every day unless you are doing an incremental load where you save the result into qvd after each reload.
date(today(),'Specify format ')-8 as NewDate
That's great, thanks Harshal. One other question, it's now coming down as a number but I want it as a dd/mm/yyyy
Slight modification:
Date(Today()-8,'Specify format ') as NewDate
Date(Today()-8,'DD/MM/YYYY') as NewDate
Hi,
try like
date(today()-8,'DD/MM/YYYY') as newDate
Kind Regards
Hi Kevin
Can you do like this,so that you will get your expected result
date(today()-8,'DD/MM/YYYY') as Date
Regards,
Sreenadha
Thats great, thanks.