topic Re: Common answer for cases where date is loaded as a value in QlikView

Common answer for cases where date is loaded as a value

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends

As per the attached data, I do not get the date loaded as value (like 48252, 48254 etc). But at some instance this happen. Mostly what I do is apply the date format as looks in the excel just under the p reloaded variables in the script such as MMM/DD/YYYY, DD-MMM-YY etc. But the excel I worked on not this one, even if I set the format as per the excel, still the date was appeared as a value. Could you please show me what area or modification need to be done to correct this. Either in the script or otherwise

Thanks in advance

Neville

Re: Common answer for cases where date is loaded as a value

vishsaggi — Fri, 24 Aug 2018 17:36:20 GMT

Did you try like

Floor(Date(Date#(DatefieldName, 'DD-MMM-YY'), 'DD/MM/YYYY')) or

Num() function.

Re: Common answer for cases where date is loaded as a value

nevilledhamsiri — Fri, 24 Aug 2018 18:08:42 GMT

Dear Vishwarath,

Could you please apply this in my attached data & send me the script & the expression

Re: Common answer for cases where date is loaded as a value

breno_morais — Fri, 24 Aug 2018 19:39:36 GMT

Can you attach the application?

Re: Common answer for cases where date is loaded as a value

vishsaggi — Fri, 24 Aug 2018 19:52:22 GMT

No source file attached can you upload please.

Re: Common answer for cases where date is loaded as a value

nevilledhamsiri — Sat, 25 Aug 2018 01:33:02 GMT

Please refer the attachment

Re: Common answer for cases where date is loaded as a value

breno_morais — Sat, 25 Aug 2018 12:02:06 GMT

Can you explain more? I think I did not get it

Your date fields already in date formart.

Re: Common answer for cases where date is loaded as a value

nevilledhamsiri — Sat, 25 Aug 2018 15:49:56 GMT

Yes Breno,

Attached data are ok. I have some data table in which nearly 99% are loaded with correct date format (dd-mmm-yy) but only couple of data are loaded with values such as 43452 etc.Unfortunately those set of data are missing now. Could you please show me if such cases were noted is it due to what reason & what expression orf set format to be used to overcome such cases

Thanks