Date time issue when entering on website

Help Studio
1

Hi ,

Im facing issue when date is being entered on website. In one server its getting entered correctly, on other server its issue. System format is different.

Also this date im extracting from pdf, where format is fixed.

2

Hi,

This issue usually happens since some websites accept date in system format only.
Like for eg : if your system date is dd/MM/yyyy format , it will accept in this only.
if you get data from invoice in MM/dd/yyyy, then you should parse it to system format and then input this date on website and vice-versa for other case.

Use this expression to get format of system.

The image illustrates a programming workflow where the date format pattern is retrieved and stored using System.Globalization. (Captioned by AI)
The image illustrates a programming workflow where the date format pattern is retrieved and stored using System.Globalization. (Captioned by AI)707×146 41.7 KB

Then add conditions to check format and parse.

if dateformat is dd/MM/yyyy, parse like this and vice-versa.

This image shows a logic flow condition with date format checking and assignment in a programming workflow. (Captioned by AI)
This image shows a logic flow condition with date format checking and assignment in a programming workflow. (Captioned by AI)470×198 32.6 KB

This image depicts a programming interface showing an assignment operation for parsing and formatting a date value using specific instructions in the software workflow. (Captioned by AI)
This image depicts a programming interface showing an assignment operation for parsing and formatting a date value using specific instructions in the software workflow. (Captioned by AI)687×149 47.8 KB

Use this parsed date, and no issues. Do it vice-versa for the other case.

Happy Automation :slight_smile:

2 Likes
3

You have a date coming from a PDF → but System culture settings are different on two servers.

Example:

Server A expects: “dd/MM/yyyy”
Server B expects: “MM/dd/yyyy”
PDF always gives: “fixed format” (ex: 27-11-2025 or 2025/11/27)

When you enter the date directly from PDF into the website, the wrong server interprets it differently → incorrect or invalid date entry.
So if you are not sure about what formats the website accepts please check below:

myDate.ToString(“dd/MM/yyyy”)
myDate.ToString(“MM/dd/yyyy”)
myDate.ToString(“yyyy-MM-dd”)

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.