Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
jonathandienst
Partner - Champion III
Partner - Champion III

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

View solution in original post

4 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

can you post the format of RL.CALL_DATE_RECD

Regards

ASHFAQ

jonathandienst
Partner - Champion III
Partner - Champion III

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
Author

They are both in a number Format.

ashfaq_haseeb
Champion III
Champion III

try like this

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


Regards

ASHFAQ