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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

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.

Top Solution Authors
Top Kudoed Authors
Users online (3,469)