DATA Step, Macro, Functions and more

First day of the current month

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 19
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,118

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,118

Re: First day of the current month

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

Occasional Contributor
Posts: 19

Re: First day of the current month

Posted in reply to FreelanceReinhard

Thanks so much!

Occasional Contributor
Posts: 19

Re: First day of the current month

And what would it be if its a datetime format?

Trusted Advisor
Posts: 1,118

Re: First day of the current month

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

 

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

☑ This topic is solved.

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

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