Cleaning Data

Format Date/Time (EU)

Normalize any date specified in the input with the following format
DD/MM/YYYY

If you don't have the information output: N/A

Input: "{{date}}"
Output:

Copy this prompt to the clipboard

Your input

Example Inputs

1. ‘03-21-2022’

2. ‘July 4, 1776’

3. ‘12/25/2021’

4. ‘’

Output

Example Outputs

1. 21/03/2022

2. 04/07/1776

3. 25/12/2021

4. N/A

Use this prompt in lemlist

How to find this variable?

Dates can be sourced from documents, databases, or digital records where standardized formats are not always used. Ensuring uniformity in date formatting helps in maintaining consistency across records and communications.

Related prompts

View all prompts