Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Specific Date = Now

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Specific Date = Now

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
4 Replies

Re: Specific Date = Now

Hi,

can you post the format of RL.CALL_DATE_RECD

Regards

ASHFAQ

MVP
MVP

Re: Specific Date = Now

Hi

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Specific Date = Now

They are both in a number Format.

Re: Specific Date = Now

try like this

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


Regards

ASHFAQ

Community Browser