First day of the current month

[ashwini2]

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 ?

[FreelanceReinh · Accepted solution]

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

[ashwini2]

Thanks so much!

[ashwini2]

And what would it be if its a datetime format?

[FreelanceReinh]

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

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