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.
