Get date, send email on that date but at specific time in AEST

[xxxxmints]

Hi there

I have a due date column the user fills in when an approval workflow is initiated, say 10 Dec.

I'd like to send a reminder email on the due date (10 Dec) but it's to send at 9 am.

But I'm also on Aust Eastern Standard Time. From my calculation if I put work on UTC at 10 pm it should be AEST 8 am or 9 am (depending on daylight savings). I'm not fussed if it is 8 or 9 am.

See pics to see what I've come up with from my searching to make the time 9 am.

So, just to check I put the End Time in a SharePoint column it comes up as 11 Dec at 10 am. In the running flow it is 10 Dec at 22 pm. I have no idea which time it is going to send it and neither are the correct times.

Any help would be appreciated.

[tom_riha · Accepted solution]

Hello @xxxxmints ,

I'd try different approach to build the dates. Instead of concat() and building the the date I'd use 2 expressions: startOfDay() to get the Due date at 00:00:00 UTC and addHours() to adjust the hours to your time zone + the wish time.

addHours(startOfDay([DueDate]),-1)

 That should take Dec 10, 00:00 UTC -1 hour = Dec 9, 11PM UTC +10 hours (UTC to AEST) = Dec 10, 9 AM

[xxxxmints]

Ok, thanks. Sounds great! I'll give that a test and will get back to you.

[xxxxmints]

OMG it worked! Thank you.