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?
Solved
Match date to End of Month (EOM) date
+3Best answer by MarkShnierYou
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])
This topic has been closed for replies.
+24I 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])
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.