Showing results for 
Search instead for 
Did you mean: 

We're looking into an issue with broken attachments right now. Please stay tuned!

First day of previous month calculation

Blue LED
I have a date field and I only want to look at the first day of the previous month, how would I obtain that? Would I use a calculation on the date field to get me the first day of the previous month?
Labels (1)
0 Kudos
1 Reply
Linear Actuator
Hi @grifc5, 

If I understand your question correctly, you have a date column with lets say a value "2020-02-19". When you apply this function you would like the value of "2020-01-01". If that's the expectation, please use the below computed column expression. 
DATETRUNC(DATEADD(@became_customer@ , -1, "months"), "months")
where became_customer is the name of my date column. 

Please let me know in case of any further questions. 

Shyam Ayyar
Product Manager
0 Kudos