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.

3 Answers 3


You need two calculated columns and apply filter

  1. Start of the Month

    =DATE(YEAR(DateField),MONTH( DateField),1)
  2. End of the Month

    =DATE(YEAR( DateField ),MONTH( DateField)+1,1)-1
  3. Filter

    "Start of the Month" is Less than or Equle to [Today]
    "End of the Month" is Greater than or Equal to [Today]

Try this formula:


A formula like below should do the trick:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.