Forum Discussion

AlanSulzer's avatar
AlanSulzer
Qrew Member
29 days ago
Solved

Match date to End of Month (EOM) date

I can't figure out how to do "=EOMONTH(A1,0)" like I can in Excel. Any ideas how to do this? The purpose is to bucketize all dates in a month across all months/years to a single date bucket for each month through time?

  • I am not familiar with that Excel function, but there are two functions that probably will give you what you want.  

    FirstDayOfMonth([My Date Field])

    LastDayOfMonth([My Date Field])

     

2 Replies

  • I am not familiar with that Excel function, but there are two functions that probably will give you what you want.  

    FirstDayOfMonth([My Date Field])

    LastDayOfMonth([My Date Field])