Maybe you can try in the "Add date time" you minus 24 hours then you add the results to your initial date time and minus one day. So you have a clean start of your day with 00:00. Somewhere along these lines
@@PowerAutomator last question, is there a reason why the Last Day Of The Month would go to the 30th of March and not the 31st? In the flow variables, the first Day Of The Month is 3/1/2024 and the First Day Of The Following Month is 4/1/2024 however, after subtract one day in the Add to datetime action I get 3/30/2024 for the last day of the previous month and not 3/31/2024.
@@groman310that is strange, did you check the bottom right to see the variable results? I can't think of any reasons to your error. Are other months also like this, i.e. 30/5?
Hi Max, you need to use the tool to convert the column datatable in a list first then use For each. Please remember to subscribe. It would really help me :)
This is awesome and I wouldn't have worked it out myself. Thank you.
how do we avoid entering a time to the variables? The time is what throws my process off.
Maybe you can try in the "Add date time" you minus 24 hours then you add the results to your initial date time and minus one day. So you have a clean start of your day with 00:00. Somewhere along these lines
@@PowerAutomator thank you for tip
Anytime mate. Too easy
@@PowerAutomator last question, is there a reason why the Last Day Of The Month would go to the 30th of March and not the 31st? In the flow variables, the first Day Of The Month is 3/1/2024 and the First Day Of The Following Month is 4/1/2024 however, after subtract one day in the Add to datetime action I get 3/30/2024 for the last day of the previous month and not 3/31/2024.
@@groman310that is strange, did you check the bottom right to see the variable results? I can't think of any reasons to your error. Are other months also like this, i.e. 30/5?
Is possivel formatted text to time for a Range of dates on excel ?
Hi Max, you need to use the tool to convert the column datatable in a list first then use For each. Please remember to subscribe. It would really help me :)
@@PowerAutomator thanks for take a moment to respond🙂, I follow the channel since some months before, your videos are greats
Thank you brother! My videos need to improve
How to get the last Friday date of previous month?
how to get last day of the month
Try get the first day of the following month then minus one day
Remember to subscribe :)