Power Automate Date Time Operation

In this video, you will learn 7 key DateTime action/expression available in power automate.
Video Chapter:
00:00 Welcome
00:35​ Topic Introduction
03:04​ How to convert time zone
05:22​ How to format DateTime
07:57​ How to Add to /subtract from DateTime
09:38​ How to compare dates
12:09​ How to calculate DateTime difference
16:17​ How to check weekends
20:36​ Excel DateTime
Reference Information:
Ticks:
Ticks per day 864,000,000,000
Ticks per hour 36,000,000,000
Ticks per minute 600,000,000
Ticks per second 10,000,000
Ticks per millisecond 10,000

[@nealtite5109]

Nice video man, easy to follow and understand, after looking through all the threads about this stuff your video definately helped the lightbulb finally go off!

[@DeepakShrivastava]

Awesome, thank you!

[@bonvoyhajj]

Thank you!!! This is exactly what I need!!!

[@DeepakShrivastava]

Glad it was helpful!

[@televisi]

Thanks for the explanations, helps me counting the difference between two dates.

[@DeepakShrivastava]

Glad to help! Thank You.

[@jaipalrana.]

Amazingly superb!!! I was looking for such solution! Thank you Deepak for Date | Time operations

[@DeepakShrivastava]

Thank you its my pleasure

[@MuhammadAdnan2.0]

Well done bro keep upload flows tricks

[@DeepakShrivastava]

Thanks.

[@MuhammadAdnan2.0]

@@DeepakShrivastava bro also start basics app in power app for learning for beginners

[@parulgandhi2122]

Thank you
It will be good if there is something regarding how to create team using graph api with powerautomate and other team related operations for example create tab, channels etc. Is it possible to do video on this?
Thanks again

[@DeepakShrivastava]

Thanks Parul. Good idea I have this in my list of future video so stay tuned.

[@bhuvanamaddineni9552]

Hi Nice Video, always nice explanation. How could we compare datetime from excel 01-01-2020 00:03 and current date time to trigger an email.
I want to trigger the email based on timings
01-01-2023 00:30
01-01-2023 01:00
01-01-2023 02:00
can u please help here.

[@MohammadAli-ts2ev]

Helpful video..
Can u plz let us know as how to skip (to format) a cell containing with text value like "NA".
I have a table where there is a date column and it contains NA and other comments as well where there is no date..
Plz help..I am stuck here.
Also, plz make a video on how to connect power automate flow with a shared file on Onedrive...

[@DeepakShrivastava]

Thanks for watching. I will add these points to my future video list.

[@mikeandchrista6768]

Hello! I have a flow the creates a planner task based on a form. How can I add days to the end date in the planner?

[@DeepakShrivastava]

You can use expression formula addDays() or "Date time: connector to add days to end date.

[@mankirattalkies1350]

I have to calculate day difference between today and first time modified date. Please tell me how to that

[@sundrapillay6668]

Thanks Deepak

[@DeepakShrivastava]

Your welcome!

[@hannawg7747]

Thank you Deepak learn a lot from your videos. How do I extract 10th day name each month?

[@DeepakShrivastava]

Thanks for watching. to get 10th day name of current month use this expression : dayOfWeek(addDays(startOfMonth(utcNow()),10))
you replace utcNow() with other date.
in response you will get a number that represent:
0 Sunday
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday

[@hannawg7747]

Thank you Deepak !
How to get 10th day name each month?

[@gopalakrishnanramamoorthy187]

I want get this function =Text([Date],"YYYYMMDD".) Can you help me in power automate i am using Sharepoint as Database

[@DeepakShrivastava]

You should use "formatdatetime" function or "DateTime" connector to convert the date to desire format.

[@gopalakrishnanramamoorthy187]

@@DeepakShrivastava Thank you..