Convert datetime to text Action(Power Automate Desktop)
This Action converts a date/time into a variable of text type.
This is the counterpart to "Convert text to datetime" and is similar to Excel's TEXT function.
How to use
Drag Convert datetime to text from Text onto the Workspace.
Set parameters.
Parameters
Datetime to convert
Specify the target date/time.
Format to use
Select whether the "datetime to convert" is the default format (Standard) or any date format (Custom).
Standard
The following table shows the choices and an example of specifying 11:30:45 on 5/10/2023.
| Select | Example Results |
|---|---|
| Short date | 05/10/2023 |
| Long date | Wednesday, May, 10, 2023 |
| Short time | 11:30 PM |
| Long time | 11:30:45 PM |
| Full datetime(short time) | Wednesday, May, 10, 2023 11:30 PM |
| Full datetime(long time) | Wednesday, May, 10, 2023 11:30:45 PM |
| General datetime(short time) | 05/10/2023 11:30 PM |
| General datetime(long time) | 05/10/2023 11:30:45 PM |
| Sortable datetime | 2023-05-10T12:30:45 |
Custom
Specify for any date format.
Specify the date in "yyyyMMMdd" and the time in "hhmmss".
Variables produced
FormattedDateTime
The resulting text of the conversion is stored.
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.