topic Re: DATE or DATE() in SAS EG 4.3 Query Builder in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126593#M10417 <HTML><HEAD></HEAD><BODY><P>DATE() = TODAY()</P><P></P><P>But TODAY() is indeed more self_documenting!</P></BODY></HTML> Tue, 29 Oct 2013 04:25:22 GMT JerryLeBreton 2013-10-29T04:25:22Z DATE or DATE() in SAS EG 4.3 Query Builder https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126588#M10412 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to apply a Filter for a date field where the Results should be all data with an End_Date Greater than today.</P><P></P><P>I've tried adding DATE &amp; DATE() but it's not being accepted.</P><P></P><P>What is the correct syntax for the query builder?</P><P></P><P>Thanks&nbsp; </P></BODY></HTML> Tue, 29 Oct 2013 03:40:43 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126588#M10412 pcfriendly 2013-10-29T03:40:43Z Re: DATE or DATE() in SAS EG 4.3 Query Builder https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126589#M10413 <HTML><HEAD></HEAD><BODY><P>If <STRONG>d</STRONG> is your date variable...</P><P><IMG alt="filter.JPG" class="jive-image" src="https://communities.sas.com/legacyfs/online/4459_filter.JPG" /></P></BODY></HTML> Tue, 29 Oct 2013 04:00:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126589#M10413 JerryLeBreton 2013-10-29T04:00:45Z Re: DATE or DATE() in SAS EG 4.3 Query Builder https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126590#M10414 <HTML><HEAD></HEAD><BODY><P>If you're looking for the function that will return today's date, try TODAY().</P><P></P><P>Tom</P></BODY></HTML> Tue, 29 Oct 2013 04:01:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126590#M10414 TomKari 2013-10-29T04:01:49Z Re: DATE or DATE() in SAS EG 4.3 Query Builder https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126591#M10415 <HTML><HEAD></HEAD><BODY><P>Thanks Jerry, I didn't think of a Function. </P></BODY></HTML> Tue, 29 Oct 2013 04:07:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126591#M10415 pcfriendly 2013-10-29T04:07:30Z Re: DATE or DATE() in SAS EG 4.3 Query Builder https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126592#M10416 <HTML><HEAD></HEAD><BODY><P>Thanks Tom !</P></BODY></HTML> Tue, 29 Oct 2013 04:07:57 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126592#M10416 pcfriendly 2013-10-29T04:07:57Z Re: DATE or DATE() in SAS EG 4.3 Query Builder https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126593#M10417 <HTML><HEAD></HEAD><BODY><P>DATE() = TODAY()</P><P></P><P>But TODAY() is indeed more self_documenting!</P></BODY></HTML> Tue, 29 Oct 2013 04:25:22 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/DATE-or-DATE-in-SAS-EG-4-3-Query-Builder/m-p/126593#M10417 JerryLeBreton 2013-10-29T04:25:22Z