Setting a date column to the 1st of the Month

I am collecting data for a report and the data i want to show is to include everything from the previous month. At the minute i manually change a date column to the 1st of the current month so that it filters out everything that has been added this month.

I have found this formula =MONTH(TODAY()) + "/" + 1 + "/" + YEAR(TODAY()) but as i am in the UK this returns the date in the US format and my data is not correct.

Is there a way to change the formula so that the date returned is in the UK format (DD/MM/YY)

Find more posts tagged with

Accepted answers

Etienne Mermillod

Hi,

To get the first day of the current month you can use this formula:

=TODAY(1 - DAY(TODAY()))

All comments

Etienne Mermillod

Hi,

To get the first day of the current month you can use this formula:

=TODAY(1 - DAY(TODAY()))

Dave Godfrey

@Etienne Mermillod that is great thank you

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.