topic How to add date field? in QlikView

How to add date field?

Anonymous — Wed, 08 Aug 2018 07:15:15 GMT

Hi all i have field like Sales, Product. how to add Date field in table box or back end .

Chanty4u — Wed, 08 Aug 2018 07:21:24 GMT

what you want exactly? explain briefly?

Anonymous — Wed, 08 Aug 2018 07:36:50 GMT

i have a excel file field sales,Product. i want add to date field in table box

sibin_jacob — Wed, 08 Aug 2018 07:49:23 GMT

If you want to show Current Date then use Today() function.

for last data loaded Date, you can use reloadtime() function.

Please share little more details.

Anonymous — Wed, 08 Aug 2018 09:55:35 GMT

i have date 100 rows like date 2018-06-01 we need change all 1-jun-18

Chanty4u — Wed, 08 Aug 2018 09:58:59 GMT

try in qlik script like this

date(Date#(Datefield,'YYYY-MM-DD'),'DD-MMM-YY' ) AS NewDate

Anonymous — Wed, 08 Aug 2018 10:17:05 GMT

2018-06-01 01:50:18 this convert to 1-jun-18

Chanty4u — Wed, 08 Aug 2018 10:18:27 GMT

try this

date(Date#(Datefield,'YYYY-MM-DD hh:mm:ss'),'DD-MMM-YY' ) AS NewDate

sibin_jacob — Wed, 08 Aug 2018 10:18:42 GMT

use this one

date(Date#(Datefield,'YYYY-MM-DD hh:mm:ss'),'DD-MMM-YY' ) AS NewDate