topic Re: Another date format question :-) in QlikView

Another date format question :-)

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Another date format question :-)

sunny_talwar — Mon, 28 Nov 2016 17:48:44 GMT

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

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

Re: Another date format question :-)

Anonymous — Mon, 28 Nov 2016 18:18:07 GMT

Thanks

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

/des

Re: Another date format question :-)

MarcoWedel — Mon, 28 Nov 2016 22:05:30 GMT

another option:

DayName([Insert time]) as Date