Another date format question :-)

[Anonymous]

Hi

I have made some progress with my qlik adventure since the help i got with the date text below.

However in my latest file the date does not seem to be in date format but rather as a number. When i use the Date to create a view of the last 3 days events i get a trend like this

The Insert time column in excel is

Insert time

2016-09-17-15.23.00.000000

2016-09-17-15.23.01.000000

2016-09-17-15.23.01.000001

2016-09-17-15.31.07.000000

And i have tried to format as date before upload.

Could somebody let me know what i am doing wrong.

Thanks

Des

[sunny_talwar · Accepted solution]

I think your date is not a date, but a timestamp. Try like this

Date(Floor([Insert time])) as Date

[Anonymous]

Thanks

Back to the drawing board now to learn about the Floor function.

/des

[MarcoWedel]

another option:

DayName([Insert time]) as Date

see also:

dayname

hope this helps

regards

Marco