topic Date function in QlikView

Date function

mario-sarkis — Mon, 15 Feb 2016 07:35:21 GMT

hey all

i have a field looks like this :

example

6/1/2015 10:00:00AM

in need to show the data when this field is greater than today

hope you can help

‌

Re: Date function

deepakqlikview_123 — Mon, 15 Feb 2016 07:37:32 GMT

If(Date(Yourfield,'DD/MM/YYYY')>Date(Today),Date(Youfield,'DD/MM/YYYY'))

Re: Date function

Anonymous — Mon, 15 Feb 2016 07:47:34 GMT

Just editing?

=If(Date(Yourfield,'DD/MM/YYYY')>Date(Today,'DD/MM/YYYY'),Date(Yourfield,'DD/MM/YYYY'))

Re: Date function

jonathandienst — Mon, 15 Feb 2016 08:14:54 GMT

If this is a text field (it will be left aligned in a list box), then the correct approach is to convert this field to a proper date/time field during the load:

LOAD

...

TimeStamp#(dateField, 'd/M/yyyy hh:mm:ssTT') As dateField

...

Now you can do simple compare:

If(dateField > today(), ....)

If(floor(dateField) > today(), ...)

(depending on your requirements)

Re: Date function

tamilarasu — Mon, 15 Feb 2016 08:18:43 GMT

Hi Mario,

Try,

=If(Date(Date#(YourFieldName,'DD/MM/YYYY hh:mm:ss tt'),'DD/MM/YYYY')> Date(Today(),'DD/MM/YYYY'),YourFieldName)

=If(Date(Left(YourFieldName,8),'DD/MM/YYYY')> Date(Today(),'DD/MM/YYYY'),YourFieldName)