topic Re: New Date Field in QlikView

New Date Field

kevbrown — Thu, 28 Apr 2016 10:25:50 GMT

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

Re: New Date Field

sunny_talwar — Thu, 28 Apr 2016 10:26:59 GMT

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.

Re: New Date Field

Thu, 28 Apr 2016 10:27:14 GMT

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

Re: New Date Field

kevbrown — Thu, 28 Apr 2016 10:32:43 GMT

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

Re: New Date Field

sunny_talwar — Thu, 28 Apr 2016 10:34:12 GMT

Slight modification:

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

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

Re: New Date Field

PrashantSangle — Thu, 28 Apr 2016 10:34:27 GMT

Hi,

try like

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

Kind Regards

Re: New Date Field

Thu, 28 Apr 2016 10:39:05 GMT

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

Re: New Date Field

kevbrown — Thu, 28 Apr 2016 10:44:07 GMT

Thats great, thanks.