Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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.
Aug 17, 2022 12:53 PM
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:
That way data entry would be slightly smoother, while still retaining all your functionality?
Apologies if I’m off the mark here!
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.
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.
Aug 17, 2022 12:53 PM
Thank you that was very simple and much appreciated!