Cleaning Data
Format Date/Time (US)
Normalize any date specified in the input with the following format
MM/DD/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. 03/21/2022
2. 04/07/1776
3. 12/25/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.
Thanks! You've successfully subscribed to lemlist newsletter
Oops! Something went wrong while submitting the form.
