topic Re: Date Formatted Not Showing in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177778#M13641 <HTML><HEAD></HEAD><BODY><P>Thank you. It worked!</P></BODY></HTML> Fri, 20 Feb 2015 23:14:55 GMT sdang 2015-02-20T23:14:55Z Date Formatted Not Showing https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177776#M13639 <HTML><HEAD></HEAD><BODY><P>The column date is in this format:&nbsp; "30AUG2001:15:59:54.970"</P><P></P><P>The syntax:</P><P>t1.AccountCreated &gt;="01JAN2014:00:00:00.000"d and t1.AccountCreated &lt;="01DEC2014:00:00:00.000"d</P><P></P><P>is valid but no data appear.&nbsp; It just gave me a blank screen.&nbsp; What did I do wrong?</P><P></P><P>Thanks</P></BODY></HTML> Fri, 20 Feb 2015 23:08:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177776#M13639 sdang 2015-02-20T23:08:32Z Re: Date Formatted Not Showing https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177777#M13640 <HTML><HEAD></HEAD><BODY><P>It's valid, but not what you intend, use DT to specify a Datetime constant not D. </P><P>Try the following:</P><P></P><P><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; background-color: #ffffff;">t1.AccountCreated &gt;="01JAN2014:00:00:00.000"dt and t1.AccountCreated &lt;="01DEC2014:00:00:00.000"dt</SPAN></P></BODY></HTML> Fri, 20 Feb 2015 23:12:21 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177777#M13640 Reeza 2015-02-20T23:12:21Z Re: Date Formatted Not Showing https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177778#M13641 <HTML><HEAD></HEAD><BODY><P>Thank you. It worked!</P></BODY></HTML> Fri, 20 Feb 2015 23:14:55 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Date-Formatted-Not-Showing/m-p/177778#M13641 sdang 2015-02-20T23:14:55Z