Is it possible to create a calculated column that takes a date field and sets the value to the first day of that month?
I want to create a view that only shows the current month events. Basically, I do NOT want to see past month events in my view.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this communityIs it possible to create a calculated column that takes a date field and sets the value to the first day of that month?
I want to create a view that only shows the current month events. Basically, I do NOT want to see past month events in my view.
You need two calculated columns and apply filter
Start of the Month
=DATE(YEAR(DateField),MONTH( DateField),1)
End of the Month
=DATE(YEAR( DateField ),MONTH( DateField)+1,1)-1
Filter
"Start of the Month" is Less than or Equle to [Today]
Or
"End of the Month" is Greater than or Equal to [Today]
A formula like below should do the trick:
=CONCATENATE(MONTH(DATE_FIELD_NAME),"/1/",YEAR(DATE_FIELD_NAME))