Hi

I have a situation with my Airtable base and I wondered if anyone can help. I realize this post is a bit lengthy and with a number of steps. Your help would be greatly appreciated.

The formula that I used is, if it helps:

DATETIME_FORMAT({DATE ISSUED},‘ddd, MMMM D, YYYY’)

I was sent this to resolve the issue of keeping the date format when I import a CSV file. I have about 1,400 records and I don’t really want to manually change the dates and I do have a date formula, but I am having a bit of a hard time following these steps. I have about 14 fields in my base. I should mention that I was able to create a view with “Fixed Date View” field with the formula, but I don’t know what to do next, (the view has all 14 fields), since the base is not working properly (I cannot add any other imported CSV files/records). I wondered if someone can help me with the rest.

I am planning on using an integration app to “catch” all duplicate records.

This was the suggestion:

To fix both of your issues at once, I would suggest creating a staging table for your imports with a few fields to make this process go more smoothly. I don’t know your exact setup but based a little off your screenshots lets say you have a table with a RecordID (to help identify existing records) as well as the fields of Stamp Description, Subject and Date Issued.

Create a staging table in addition to the table that the records will ultimately reside in. This staging table can be all text fields which is perfectly fine.
Add a formula to the staging table that converts your text date of “Wed., May 23, 2018” to an actual date field. Change the formatting of that formula field to not use time.
Create a view named “Fixed Date View” or something descriptive that uses this new date from the formula and hides the old text date.
You could at this point copy and paste from the staging table’s “Fixed Date View” to the actual table the records will be in.