Question

Limited Date Formats in Forms - What About MM/dd?

Workflow Forms How To

Updated May 28, 2020

asked on August 21, 2019

Is there a best practice to display the MM/dd portion only of a date field in Forms? In this instance, I have a date field that is being passed over via a workflow process from repository metadata. The metadata seems to give me plenty of formatting flexibility but Forms seems more restrictive (see images) Optimally, the Date format drop down would give this option.

If the answer is no to any field settings in Forms, I'm wondering if someone could give suggestions.

Having the data land in forms as a date format matters little so I'm open to using a text field in Forms if there is a means to convert the date field to a text field using Workflow. I'm wondering if there might be some magic with tokens but have not been able to figure it out in our sandbox thus far.

Thank you in advance!

LFFormsDateFormat.png (14.77 KB)

| Download

LFAdminConsoleDateSettings.png (5.69 KB)

| Download

0 0

Replies

replied on August 22, 2019

Hi Sandra

You have found a current limitation to the Date Field in Forms.

One option is to have the Date field remain in your Form but you could hide it using a FIeld Rule, and then create Single Line Field that contains a formula to show the Date you what. I assume the date will be read only so the user couldn't change it.

The formula could look like =CONCATENATE(MONTH(DatefieldVariable),"/",DAY(DatefieldVariable)) which should give you a result such as 11/22 MM/DD

Otherwise in your Workflow, you would create a string token as using your format and perform the actions as you stated about and then pass that value to a Single line field as opposed to a date field.

0 0

replied on May 11, 2020

Used the method above but the formual errors. I have a Form where I have an input Date field. When I display the contents of that same input field in another area of the form , it displays the sequence number value of the date rather than the date itself in m/d/yyyy format. Is there a function I could use ?

0 0

replied on May 28, 2020 • Show version history

MM/dd is not a valid date because it is missing the year. The repository format is for display only. The user is still required to enter a proper date when modifying the field value. Forms is a data collection tool, so it needs a complete date.

0 0

You are not allowed to follow up in this post.

Question

Question

Limited Date Formats in Forms - What About MM/dd?

Replies

Sign in to reply to this post.