Jevon_Stammers - profile

Jevon_Stammers · May 21, 2020

Hi all, New to Airtable and by no means a whizz when it comes to formulas. In short, I need to create a formula that will return a date of the 1st day of last month. In other words, today (May 21st), the field should show a date of April 1st 2020. As...

Jevon_Stammers · May 21, 2020

Perfect - thanks again @Jeremy_Oglesby That had been bugging me for hours!

Jevon_Stammers · May 21, 2020

Hi @Jeremy_Oglesby, Thanks for that - it’s working perfectly. And am I right in thinking that this would still work on the 1st of each month? My understanding of the logic is that it would try to subtract zero from the days (i.e. 1 - 0 = 1)? Thanks a...

User Statistics

User Activity

Using a formula to return the date of 1st day of last month

Re: Using a formula to return the date of 1st day of last month

Re: Using a formula to return the date of 1st day of last month