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

Planner Time Conversion

I am creating planner tasks from emails I get. I pull the email in a pull out the data I need. I am working on the planner start\due dates, these values come from the email in the format of MM-dd-yyyy. In the body of the email it loos like this:

 

Assigned to: person, some

Start Date: 03/01/2020

End Date:  03/30/2020

Hours Booked:  5.00

 

So for start date I have a few composes setup to pull 03/01/2020. Now I have tried a few things. If I set the Create Tasks "Start Date Time" to the output of the compose that has the correct value it creates everything fine just the start date is a day before the value it got from the compose...so it uses 2/29/2020. I have tired to also use Convert Time zone and used various timezone settings for force it to be the correct date but no matter what I do my output looks to be the correct date of 03/01/2020 but the task always gets 02/29/2020. Any idea why? 

 

2020-01-20_11-45-38.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

@SemiEvilMonkeyThis is leap year question that I posed a few years ago now but really did not get resolved.

View solution in original post

5 REPLIES 5
Highlighted
Frequent Visitor

I am able to make it work by using this in the format string but still dont understand why its putting it a day behind without doing this

addDays(outputs('StartDatefromEmail'),1,'yyyy-MM-dd')

 

 

Highlighted
Community Support
Community Support

Hi @SemiEvilMonkey ,

 

Could you please share a screenshot of the configuration of the flow that use the date 02/29/2020 to replace the date 03/01/2020?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted

@SemiEvilMonkeyThis is leap year question that I posed a few years ago now but really did not get resolved.

View solution in original post

Highlighted

Thanks
Highlighted

@SemiEvilMonkeyso if my past post helped you could you help me understand how I can resolve my issue.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (8,846)