
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2022 07:25 AM
This seems simple but I am not sure how to accomplish this. I have my educators complete a form that requires them to enter their course start dates in ISO. This format is important for some concatenate fields and dropdown menus in other tables and forms, and thus I cannot change the format when the forms are completed. Currently, I am asking my instructors to enter the date twice: Once as ISO and once as friendly. In order to avoid entry mistakes and disgruntlement amongst the ranks, I would love to be able to do this with a formula.
In short, I would my like instructors to enter the date as ISO and then in a second field the friendly date format populates magically. This: 2021-06-11 becomes June 6, 2021 in a second field.
Thank you for your help.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2022 12:53 PM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2022 07:39 AM
Hi Kirsten, I take it they’re keying that into a single line text field?
If so, you could try creating a formula field with the following formula:
DATETIME_PARSE(
{Date ISO},
"YYYY-MM-DD"
)
And changing the formatting of the field
Resulting in this:
I was wondering whether it would be possible to let your instructors key in the start dates into a date field, and then creating two new fields:
- One for the friendly version
- One for the ISO version
That way data entry would be slightly smoother, while still retaining all your functionality?
Apologies if I’m off the mark here!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2022 07:43 AM
Thanks Adam,
They are keying it into a date field (ISO). And I am trying to figure out how to get that date into a friendly date format field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2022 11:04 AM
Hi @Kirsten_Kern,
You can add a formula field, set the formula to just be your Course Start Date, then format the Formula field to Friendly.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 17, 2022 12:53 PM
Thank you that was very simple and much appreciated!
