Date Field changes to YYYY-MM-DD format automatically

[immortalsolitude]

I have set up the date action to input date in to a web form. the date is written as and expression Today() however when the date is entered in to the form it converts it into YYYY-MM-DD format. How do i make this stick to the MM-DD-YYYY format that the form is expecting?

 

[nickbell123]

I have set up the date action to input date in to a web form. the date is written as and expression Today() however when the date is entered in to the form it converts it into YYYY-MM-DD format. How do i make this stick to the MM-DD-YYYY format that the form is expecting?

Use FormatDate(Today(),"MM-dd-yyyy"))

 

[bot1robot]

Agree with @nickbell123 , you may Use FormatDate(Today(),"MM-dd-yyyy")) inside expression editior as attached in screen shot.

Pls mark thread as solved if you find solution .

View attachment 1548309399166.png

 

[immortalsolitude]

That didnt help it still writes the same way YYYY-MM-DD What i have is FormatDate([Date Of Signing],"MM-dd-yyyy") Where [Date Of Signing] is the date in MM-DD-YYYY format coming from the form.

 

[bot1robot]

@immortalsolitude
Try to use separate data Item for this date field and track the value , how it is showing in data item .
Share screen shot if issue still persists with above approach.

 

[sivagelli]

I have set up the date action to input date in to a web form. the date is written as and expression Today() however when the date is entered in to the form it converts it into YYYY-MM-DD format. How do i make this stick to the MM-DD-YYYY format that the form is expecting?

Is the form converting the date passed to a different format? What is the acceptable format in to the date field on the form?

 

[immortalsolitude]

Is the form converting the date passed to a different format? What is the acceptable format in to the date field on the form?

Yes the date is converted into YYYY-MM_DD format when it is sent from BluePrism to the form but when the form is saved it does give warning but when "next" is clicked it converts it to MM-DD-YYYY format again and proceeds.

@immortalsolitude
Try to use separate data Item for this date field and track the value , how it is showing in data item .
Share screen shot if issue still persists with above approach.

Yes the issue still persists, here's the screen shot

View attachment 1548428765006.png

 

[immortalsolitude]

Is the form converting the date passed to a different format? What is the acceptable format in to the date field on the form?

Here i am manually entering the date as it is being sent by blueprism

View attachment 1548429033242.png

As you can see in the second screenshot the form gave an error but converted the date in correct format.

 

[sivagelli]

Yes the issue still persists, here's the screen shot

View attachment 1548428765006.png

You are missing a 'y' in the expression.

 

[immortalsolitude]

You are missing a 'y' in the expression.

Still the same result

View attachment 1548429945867.png

 

[sivagelli]

Alright! I see it now. BP is getting you the date in yyyy mm dd format irrespective of the formating. Is it only in BP? Let's try this-
Can you store Today() with no format in to a Data Item?
Also, go to excel sheet and try =Now() in any cell.

 

[immortalsolitude]

Alright! I see it now. BP is getting you the date in yyyy mm dd format irrespective of the formating. Is it only in BP? Let's try this-
Can you store Today() with no format in to a Data Item?
Also, go to excel sheet and try =Now() in any cell.

Still the same , Today() in excel works fine.

View attachment 1548441323905.png

 

[immortalsolitude]

Still the same , Today() in excel works fine.

View attachment 3155

When i evaluate the expression i get the correct value in MM-dd-yyyy but when the data is entered in to the web form it changes to yyyy-MM-dd

 

[bot1robot]

@immortalsolitude
Can you try running this on different machine and confirm the result. ? It seems some issue with regional settings.

 

[immortalsolitude]

@immortalsolitude
Can you try running this on different machine and confirm the result. ? It seems some issue with regional settings.

Ran this on other server and same problem, where would i check for regional settings?

 

[bot1robot]

@immortalsolitude
Under Control Panel ==>Region and Language . You may check Date Format .

 

[immortalsolitude]

Its in the correct format mm-dd-yyyy

 

[sivagelli]

Can you give a try using GSK?

 

[immortalsolitude]

GSK for Date? The Date needs to be an input based on the date received from the form Not sure how GSK would work here

 

[anjali]

Hi ,
You can use the below code to get the date in a required date format, in case none of the above is working . It will surely give the date as per your requirement
string GetDate= Convert.ToDateTime("<your-datetime").ToString("MM-DD-YYYY "); You can use the ToString function to pass the format that you want the object to take.

MM