topic Re: Dates in QlikView

Dates

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

I have an app which is loading in dates as datetime field. I've created a calendar from this datetime field but when making selections on the calendar controls it isn't work. I've attached some sample data for yesterdays date. As you can see there are many rows that contain the date 19/07/2016 hh:mm:ss but when you use the calendar controls on dates with 19/07/2016 00:00:00 shows, why?

Re: Dates

danansell42 — Wed, 20 Jul 2016 14:54:13 GMT

Hi Kevin

Wasn't able to open the app.

Its probably worth rounding down the date field to remove the hh:mm:ss.

I usually use the floor function.

This should resolve the issue

Dan

Re: Dates

Anonymous — Wed, 20 Jul 2016 14:59:48 GMT

Hi Kevin

Use Date(Floor(YourDatefield),'DD/MM/YYYY') in your load script and this swill strip out the date part of the datestamp and then this will associate correctly with the master calendar.

Hope this works for you.

Re: Dates

effinty2112 — Wed, 20 Jul 2016 15:03:55 GMT

Hi Kevin,

Looks like your dates are formatted as timestamps.

Try this expression in your frontend or in your load script.

Date(Floor(Timestamp#(YourField, 'DD/MM/YYYY hh:mm:ss')))

When Timestamp# converts your field to a number Floor will drop any fractional part.

Cheers

Andrew

Re: Dates

kevbrown — Thu, 21 Jul 2016 12:45:25 GMT

None of the suggestions work

Re: Dates

kevbrown — Thu, 21 Jul 2016 12:45:50 GMT

This is giving me 00 for months

Re: Dates

kevbrown — Thu, 21 Jul 2016 12:48:27 GMT

It is working!! Thanks

Re: Dates

Anonymous — Thu, 21 Jul 2016 13:15:49 GMT

You're welcome Kevin. We all go through nightmares with dates. Glad it's working now and any other issues that's why the community is there for us all.