num(date#)

[anushree1]

Hi,

I am using CSV File on Qliksense and would like to add 3 days to the date field due to which i am first converting the date to num using the below code, but it results in blank values though order date has valid values, can someone help me on this issue

Num(Date("Order Date", 'DDMMYYYY')) AS NumericDate,

[Uday_Pasupuleti]

Did you try Num#() ?

[anushree1]

i did

[Uday_Pasupuleti]

Try Num#() without the date and see whether it shows any values or not.

If it shows values then use preceding load to convert to a date format.

[jood_ahmad]

 try to convert the date to the date num and add the date that you want and if the data has a time stamp try to use the floor function then add the date you need then convert it to the date format 

[anushree1]

i used num#("Order Date") as num,

it gives me same value as OrderDate,

as i am using Qliksense i cannot change the format in front end on list box as in qlikview to check it actual format

[Uday_Pasupuleti]

Try
Num(Date(Num#("Order Date"),'DD/MM/YYYY')) as Num

[anushree1]

its giving me blank values

[Uday_Pasupuleti]

Will you be able to send that a sample set of data?

Few rows of that field should be good enough.

[jood_ahmad]

can you share a sample