Importing Date Fields

Through this post, it will hope to introduce the date field and to show how to import a date field from a CSV import file into a group of records. The date field will present to the user with a date selection which will be stored in the format of yyyy-mm-ddThh:mm:ssZ. For example, a date of 29/08/2020 would have a backing value of 2020-08-29T00:00:00Z but still be imported with a value of 29/08/2020.

To import a date field you would need to first create a the date field in App Studio which you can find here.

Once created, the records that you which to import the date fields into would need to be exported as a CSV file which is found here. When completed and the Date field ID is found in the CSV file, fill in the cells with the dates you wish to use. Also, the time following the date is not required so you can ignore the parts between T and Z as you can see in the following images where only yyyy-mm-dd is used.

After the cells has been filled in now you can now import the CSV file which can be found here. Now once completed the date fields should now be filled in with its corresponding date values.