How to add date field?

[Anonymous]

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

[Chanty4u]

what you want exactly?  explain briefly?

[Anonymous]

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

[sibin_jacob]

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]

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

[Chanty4u]

try in qlik script like this

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

[Anonymous]

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

[Chanty4u]

try this

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

[sibin_jacob]

use this one

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