Standardizing Date Format in Prompts: Tips and Advice

Hey guys, is there a way I can standardize the date format? I do explicilty say it in the prompt but it just doesnt listen. Any advice is welcome

· Sorted by Oldest

Muhammad S.
·
·
use formulas to normalize it
Bharat D.
·
·
If you want to try this in prompt give an example of good format and multiple examples of bad format. You can also say, if there is no date, return blank. If you have already run the enrichment for the complete table, then you can use the formula as Muhammad mentioned.
Marko P.
·
·
Thank you so much for the help guys
🙌1
kushagra t.
·
·
if you are not using json schema in output - would recommend generating and using that instead of output fields

Muhammad S.
·
·
use formulas to normalize it
Bharat D.
·
·
If you want to try this in prompt give an example of good format and multiple examples of bad format. You can also say, if there is no date, return blank. If you have already run the enrichment for the complete table, then you can use the formula as Muhammad mentioned.
Marko P.
·
·
Thank you so much for the help guys
🙌1
kushagra t.
·
·
if you are not using json schema in output - would recommend generating and using that instead of output fields