Skip to main content
Nintex Community Menu Bar
Question

Date and Time format

  • March 4, 2024
  • 7 replies
  • 145 views
  • Translate

Forum|alt.badge.img+5

I added a Date/time picker to the form builder and configured the picker to hide the time and restrict the past dates.  When the form is populated in the workflow, the field displays the date and time of either 6:00 AM or 12:00 AM.  See attached image.  I tried using the lookup fx FormatDate, fx date, and fx convertToDate functions to configure the output date format to show only the date in MMM-DD-YYYY, but there does not appear to be an option to achieve this.  Is there an option to configure the date output as MMM-DD-YYY, e.g., March 4, 2024?

Did this topic help you find an answer to your question?

7 replies

Deon
Forum|alt.badge.img+10
  • Rookie
  • 125 replies
  • March 4, 2024

@AdrianGaribdass01 , sure

 

Just edit the Format of the date control, select Custom and Enter MMMM dd, YYYY 

 

 

Translate

Forum|alt.badge.img+5

@Deon ,

How do I access these controls? Do I need to be assigned a specific role?

Translate

Deon
Forum|alt.badge.img+10
  • Rookie
  • 125 replies
  • March 4, 2024

@AdrianGaribdass01 , let’s just first confirm we are talking about the correct product.

This was posted under “Nintex Automation” which is the new name for K2 Five (On Prem).

Is that the product you want help with?

Translate

Forum|alt.badge.img+5

@Deon

I am using Nintex Automation Cloud. 

Translate

Deon
Forum|alt.badge.img+10
  • Rookie
  • 125 replies
  • March 5, 2024

Hi @AdrianGaribdass01 , can you perhaps send me an Export Key of your Workflow so I can have a look please?

If you don’t want to share it here, just PM me.

Translate

Forum|alt.badge.img+5

@Deon ,
I have only been using the Nintex automation cloud for two weeks and have been using the help menu and community support page. I appreciate your assistance.

When you request the export key, are you referring to the Form URL and snippet?

Translate

Deon
Forum|alt.badge.img+10
  • Rookie
  • 125 replies
  • March 6, 2024

Hi @AdrianGaribdass01

If you wanted to format the date in a specific way, you can just drag a single-text control onto the Form, set it to Read Only and make the default value this Formula:

 

formatDate([Workflow].[Start event variables].[Form variables].[Date of Birth],"MMMM DD, YYYY")

 

Regards

 

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings