How to truncate the time portion from the date and time. (Power Automate Desktop)


Japanese version.

This section shows how to truncate the time portion from the Datetime to only the date.


Drag "Convert datetime to text" under "Text".

Then, set parameters as follows.

Datetime to convertTarget Datetime.
Format to be useStandard
Standard formatShort date

When the flow is run, The result of the "Convert datetime to text" action (variable name FormatterDateTime by default) will contain a date with the time truncated.

This FormatterDateTime can also be used in "Date time" related actions and in the "Display select date dialog" action.

For those who want to learn Power Automate Desktop effectively

The information on this site is now available in an easy-to-read e-book format.

Or Kindle Unlimited (unlimited reading).

You willl discover how to about basic operations.

By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.

Table of Contents.

Update History.


Date time Actions