You’re offline. This is a read only version of the page.
13
Hi,
How do I get the last date of the year in mm/dd/yyyy formate?
And how do I get the first date of the year in mm/dd/yyyy formate?
Thank you
To get the first day or last day of the current year you would use:
Share
Report
All responses (
Answers (
Date(Year(Today()),1,1)
Date(Year(Today()),12,31)
To get the first or last day of a given date, replace the Today() portion of the function above with the date value. Eg:
Date(Year(DatePicker2.SelectedDate),1,1)
Date(Year(DatePicker2.SelectedDate),12,31)
If you wish to present the date in mm/dd/yyyy format, use Text() to format the returned date to the desired pattern.
Eg:
Text(Date(Year(Today()),12,31),"mm/dd/yyyy")
