topic Re: Date Expression in QlikView

Date Expression

Wed, 25 Nov 2020 16:16:04 GMT

Expression:

=if(Resolved > [Due Date],date([Due Date]),0)

can any one check whats the Problem in this Expression.
using this Expression i am getting the same dates also of the two fields. but i want only bigger dates.

INFO: I have converted the time-stamp [Due Date] into Date

Re: Date Expression

swuehl — Tue, 07 Jun 2016 08:43:42 GMT

i assume you haven't transformed the timestamp to a date, you just formatted it using date() function.

In your script, use

Date(Floor(TIMESTAMPFIELD)) as DATEFIELD

Re: Date Expression

tresB — Tue, 07 Jun 2016 08:47:11 GMT

While creating date field in the script, try using floor() like:

Date(floor(Resolved)) as Resolved

Then you would get single date in the list box for each date unlike you are having now.