New Date Field

[kevbrown]

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

[sunny_talwar]

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.

[#3 · Accepted solution]

date(today(),'Specify format ')-8 as NewDate

[kevbrown]

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

[sunny_talwar]

Slight modification:

Date(Today()-8,'Specify format ') as NewDate

Date(Today()-8,'DD/MM/YYYY') as NewDate

[PrashantSangle]

Hi,

try like

date(today()-8,'DD/MM/YYYY') as newDate

Kind Regards

[#7]

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

[kevbrown]

Thats great, thanks.