Desktop productivity for business analysts and programmers

DATE or DATE() in SAS EG 4.3 Query Builder

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

DATE or DATE() in SAS EG 4.3 Query Builder

Hi,

I want to apply a Filter for a date field where the Results should be all data with an End_Date Greater than today.

I've tried adding DATE & DATE() but it's not being accepted.

What is the correct syntax for the query builder?

Thanks 


Accepted Solutions
Solution
‎10-29-2013 12:01 AM
PROC Star
Posts: 1,143

Re: DATE or DATE() in SAS EG 4.3 Query Builder

If you're looking for the function that will return today's date, try TODAY().

Tom

View solution in original post


All Replies
Frequent Contributor
Posts: 85

Re: DATE or DATE() in SAS EG 4.3 Query Builder

If d is your date variable...

filter.JPG

Frequent Contributor
Posts: 80

Re: DATE or DATE() in SAS EG 4.3 Query Builder

Thanks Jerry, I didn't think of a Function.

Solution
‎10-29-2013 12:01 AM
PROC Star
Posts: 1,143

Re: DATE or DATE() in SAS EG 4.3 Query Builder

If you're looking for the function that will return today's date, try TODAY().

Tom

Frequent Contributor
Posts: 80

Re: DATE or DATE() in SAS EG 4.3 Query Builder

Thanks Tom !

Frequent Contributor
Posts: 85

Re: DATE or DATE() in SAS EG 4.3 Query Builder

DATE() = TODAY()

But TODAY() is indeed more self_documenting!

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 1071 views
  • 3 likes
  • 3 in conversation