web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Power apps get Dates

Power Apps

Answered

Power apps get Dates

(0) Share

Report

Report

Posted on by CU14100144-0

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

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Tony_Bowes_BP 280 on at

Like (2)

Report
Copy link

Link copied!
To get the first day or last day of the current year you would use:

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")

Was this reply helpful? Yes No

Join the conversation