cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Diamonddedo
Frequent Visitor

Get first day of the year and last Day of the month

Hi ! I'm having trouble to find a way to get the first day of the year and the last day of the actual month

 

Is there any way do this simply ? Thanks in advance

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Diamonddedo
Frequent Visitor

I've looked around a bit and found a way to do it

 

Date(Year(Now());01;01)

Here I'm setting a new Date with this year as year, and I'm setting manually the first day of the year

 

Then to get the last day of the month I did this : 

Date(Year(Now()); Month(Now()) + 1; 01 -1)

So, I'm getting this Month, adding one to get the next Month, Then I'm removing one Day so I get last day of the month

View solution in original post

1 REPLY 1
Diamonddedo
Frequent Visitor

I've looked around a bit and found a way to do it

 

Date(Year(Now());01;01)

Here I'm setting a new Date with this year as year, and I'm setting manually the first day of the year

 

Then to get the last day of the month I did this : 

Date(Year(Now()); Month(Now()) + 1; 01 -1)

So, I'm getting this Month, adding one to get the next Month, Then I'm removing one Day so I get last day of the month

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,036)