https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266439#M52523 <P>intnx('month',today(),0)</P> Tue, 26 Apr 2016 16:19:46 GMT FreelanceReinh 2016-04-26T16:19:46Z https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266434#M52518 <P>Hello!</P><P>&nbsp;</P><P>I was trying to query the first day of the current month. My query will be something like this:</P><P>&nbsp;</P><P>creation date &lt; (first day of the current month).</P><P>&nbsp;</P><P>Could somebody please help me with the syntax ?</P> Tue, 26 Apr 2016 15:59:41 GMT https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266434#M52518 ashwini2 2016-04-26T15:59:41Z https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266439#M52523 <P>intnx('month',today(),0)</P> Tue, 26 Apr 2016 16:19:46 GMT https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266439#M52523 FreelanceReinh 2016-04-26T16:19:46Z https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266441#M52524 <P>Thanks so much!</P> Tue, 26 Apr 2016 16:24:30 GMT https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266441#M52524 ashwini2 2016-04-26T16:24:30Z https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266465#M52531 <P>And what would it be if its a datetime format?</P> Tue, 26 Apr 2016 17:38:37 GMT https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266465#M52531 ashwini2 2016-04-26T17:38:37Z https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266492#M52535 <P>intnx('dtmonth',datetime(),0)</P> <P>&nbsp;</P> <P>(alternative:&nbsp;intnx('month',today(),0)*86400)</P> Tue, 26 Apr 2016 18:44:03 GMT https://communities.sas.com/t5/SAS-Programming/First-day-of-the-current-month/m-p/266492#M52535 FreelanceReinh 2016-04-26T18:44:03Z