topic Specific Date = Now in QlikView

Specific Date = Now

Mon, 06 Oct 2014 11:07:56 GMT

Hi,

In my load script I am loading from a qvd file and I have a column called RL.CALL_DATE_RECD which shows the date when a call was logged. At the end of my load script I have a where clause and I want to do is bring up all the cases where the RL.CALL_DATE_RECD = Todays Date.

I have tried WHERE DATE(RL.CALL_DATE_RECD = DATE now()), however none of my date is showing.

Would someone be able to help with this please?

Regards,

Jon Ditchfield

Re: Specific Date = Now

ashfaq_haseeb — Mon, 06 Oct 2014 11:11:10 GMT

Hi,

can you post the format of RL.CALL_DATE_RECD

Regards

ASHFAQ

Re: Specific Date = Now

jonathandienst — Mon, 06 Oct 2014 11:13:18 GMT

Assuming the field is a normal date or date/time field, then this should work:

WHERE Floor(RL.CALL_DATE_RECD) = Today(1)

HTH

Jonathan

Re: Specific Date = Now

Mon, 06 Oct 2014 11:16:36 GMT

They are both in a number Format.

Re: Specific Date = Now

ashfaq_haseeb — Mon, 06 Oct 2014 11:22:50 GMT

try like this

WHERE num(RL.CALL_DATE_RECD) = num(Today())

Regards

ASHFAQ