function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ErenEren 

Calculating the first day of the month

Hi all, I need a formula that will calculate the first day of the current month, for example, if today is 6/24/08, the field should have as a result 6/1/08. Can any of you help?
werewolfwerewolf
TODAY()-DAY(TODAY())+1
ErenEren
Perfect. Thank you!
thecrmninjathecrmninja

Saw this and wanted to also share you can use

 

 

toStartOfMonth  DateReturns the first of the month for the Date that called the method. For example, July 14, 1999 returns July 1, 1999.

 

Date Methods
*werewolf**werewolf*

Note that theCrmNinja's post refers to an Apex method, whereas my post referred to something you could use in formula fields.
umesh Karlwad 7umesh Karlwad 7
Hi, hope this works plz check

System.Date.today().toStartOfMonth()