Can You Take A Look At This?

[M_k]

Hi @Justin_Barrett

I woundered if you could give me some advice on this post. It was suggested that I use Parse Date, but I could not get it to work:

Issue With Date Formula Formulas

Hi I keep getting an error when I use this formula: DATETIME_FORMAT({DATE ISSUED},‘MM-DD-YYYY’) This is what I am trying to do: Make a second formula field using DATETIME_FORMAT({DATE ISSUED},‘MM-DD-YYYY’)^ and then copy the values for all your imported CSV entries into your original “Date Issued” field. The formula field you’re using now will then produce the result you’re after. After you do this you can delete your second formula field, and convert “Date Issued” into a date field." Basic…

Thank you,
Mary

[nea_lpatil]

@M_k

I created the following base.
Let me know if it helps .
You can check formulas in the base.

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

Reference for date-time functions

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

Neal

[M_k]

Hi @nea_lpatil

Thank you so much for your help. The formula worked.

Thank you,
Mary