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?
Solved! Go to Solution.
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
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?
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.