DATA Step, Macro, Functions and more

First day of the current month

Accepted Solution Solved
Reply
Contributor
Posts: 22
Accepted Solution

First day of the current month

Hello!

 

I was trying to query the first day of the current month. My query will be something like this:

 

creation date < (first day of the current month).

 

Could somebody please help me with the syntax ?


Accepted Solutions
Solution
‎04-26-2016 12:24 PM
Trusted Advisor
Posts: 1,256

Re: First day of the current month

intnx('month',today(),0)

View solution in original post


All Replies
Solution
‎04-26-2016 12:24 PM
Trusted Advisor
Posts: 1,256

Re: First day of the current month

intnx('month',today(),0)

Contributor
Posts: 22

Re: First day of the current month

Posted in reply to FreelanceReinhard

Thanks so much!

Contributor
Posts: 22

Re: First day of the current month

And what would it be if its a datetime format?

Trusted Advisor
Posts: 1,256

Re: First day of the current month

intnx('dtmonth',datetime(),0)

 

(alternative: intnx('month',today(),0)*86400)

🔒 This topic is solved and locked.

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

Discussion stats
  • 4 replies
  • 1443 views
  • 1 like
  • 2 in conversation