Date Strings to Different Formats

This procedure converts text to a date in a specific format.

For example, say you have a text representation of a date, such as 2024-10-23 00:00:00, and you want to convert it to a different format, such as 10/23/24.

This is done by converting the text into a datetime object and then converting it back into text into the desired format.

Syntax

convert "{text date}" to a datetime
convert the above to a text where
  the format is "{format}"

Inputs

1. text date: The text representation of a date to be converted.

2. format: The format to convert the date into.

Example

convert "2024-10-23" to a datetime
convert the above to a text where
  the format is "%m/%d/%y"

📖 Results

• 10/23/24