About date format

[lionking15]

hi,

i have create a date column in my excel sheet and given date as 19/07/2016 but after reloading the script it is coming in number format 42570 why??and how to correct it??

[oknotsen]

Dates are actually numbers (counted from Dec 31st, 1899).

If you put a Date() function around that field in your load script, all problems should be solved.

Normally dates just stay dates, so my guess is you are also loading that same field name as a number in your script or you use it in a mapping load, as mapping tables turn dates into numbers again.

[qlikviewalex]

If you load the Value. You can ad Date#()

load

...

date#( yourDate ) as yourDate

[PrashantSangle]

Hi,

just use date(dateField,'DD/MM/YYYY')

Regards

[antoniotiman]

Use

Date(DateField) as DateField

Date Field is Dual Field

Text -> 19/07/2016 and Number -> 42570

Regards

[oknotsen]

Correction: Without the #

[MindaugasBacius]

Date have both number and string interpretation.

From Reference Manual:

From QlikView Help:

[oknotsen]

Note that help is now (since QlikView 12) completely online, so there is no need to post screenshots of it. You can just link to the appropriate topic.

Qlik | Help

[MindaugasBacius]

Thanks for that!