topic Re: DATE RETREIVAL in QlikView

DATE RETREIVAL

Anonymous — Tue, 27 Mar 2018 07:39:57 GMT

Hi , i need to create a date field with the following existing fields: i do not have a date field in the model.

File base name : 2010data and sheetname is Jan : how can i make use of MakeDate function to create a date field of the format DD/MM/YYYY (01/01/2010). Can anyone suggest an idea please

Regards

Re: DATE RETREIVAL

YoussefBelloum — Tue, 27 Mar 2018 07:53:14 GMT

Hi,

what do you mean by Sheetname is Jan ?

do you want to create new date field on the script ?

Re: DATE RETREIVAL

tresB — Tue, 27 Mar 2018 08:00:16 GMT

Try like:

Load

MakeDate(Left([File base name],4), Num(Month(Date#(Sheetname, 'MMM')))) as Date

Or,

Date(Date#(Left([File base name],4)&Sheetname, 'YYYYMMM')) as Date

Re: DATE RETREIVAL

Anonymous — Tue, 27 Mar 2018 08:32:40 GMT

Hi Youssef,

yes , i need to create a new date field in the script. I have FileBaseName field as 2010data and SheetName field as Jan, Feb ,Mar ...so on ....

Thanks for your reply Youssef , i managed to sort it out.

Regards