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

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.

Get lemlist updates and news
SHARE THIS ARTICLE
Thanks! You've successfully subscribed to lemlist newsletter
Oops! Something went wrong while submitting the form.

Related prompts

View all prompts