DATE or DATE() in SAS EG 4.3 Query Builder

[pcfriendly]

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 

[JerryLeBreton]

If d is your date variable...

[pcfriendly]

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

[TomKari · Accepted solution]

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

Tom

[pcfriendly]

Thanks Tom !

[JerryLeBreton]

DATE() = TODAY()

But TODAY() is indeed more self_documenting!