If I want to specify the last day of the current month in a cell as a date, what is the syntax? In Google Sheets & MS Excel it is EOMONTH (End Of Month).
EDIT - HERE IS THE FORMULA - THANKS KAMILLE & JUSTIN
DATETIME_FORMAT(
DATEADD(
DATE...
Thank You Justin. For me your formula returned 3/30/2019, which is close enough for what I am trying to do.
I still recommend to AirTable to place End of Month into the date options. Thanks Again Justin.
Thank You Kamille. This provided the number 31. Which technically speaking is what I asked. I will tweak this code to return the EOMONTH as a date. So, rather than 31, it will return 03-31-2019. Thanks for taking the time to put together that fo...