CDate function using different locales
I am using QTP (therefore VBScript) and I seem to have a problem with the CDate function.
When my colleague in Malaysia is using it there is not a problem. When I use it here in Spain I have the following error.
Now all I am asking is if there are any known issues with this function or any other related ones like FormatDateTime between different locales.
Anybody knows this?
Thanks in advance.
The error specifies the problem. todateObject.GetROProperty("value") contains a value that CDate does not recognize as a date.
You will need to first determine what is being returned by todateObject.GetROProperty("value"), and then make sure it can be converted to a date.
You may want to consider creating the date using DateSerial instead of CDate to avoid problems arising from cultural differences. If that is the case, depending on your circumstance you may need to provide separate fields for Day, Month, and Year to assure the order is always correct.
- SimpleDateFormat ignores "XXX" if timezone is set to "UTC"
- Invalid date in safari
- Java: epoch date to MM/DD/YYYY
- how to construct and write a formula to google sheets to perform a dynamic date calculation
- If I wanted to work using dates and time going millions of years into the past/future how would I do it?
- Epoch to Date Not Working Properly
- What is going wrong in this target date calculater?
- Error using SimpleDateFormat
- How to calculate number of days between dates?
- Is `new Date(string)` reliable in modern browsers, assuming the input is a full ISO 8601 string?
- Subtract/Add days to a predefined date using Write-Host
- java.text.ParseException: Unparseable date: Mon Apr 08 00:00:00 IST 2013
- How to solve java.text.ParseException: Unparseable date?
- How to parse a date string in a foreign language with go time
- java.text.ParseException: Unparseable date: "2014-06-10T13:37:17.744Z"
- Google Sheets Script new Date() with timezone is providing wrong time
- UnParseable Date Exception :"2015-02-06T16:05:20"
- Error by converting date: Unparseable date in JAVA
- Pandas read_sql_query - date params
- java.text.ParseException: Unparseable date Exception while converting timestamp value to time in java
- DATEDIFF vs (w1.date = w2.date +1) difference? MySQL syntax
- Obtaining last Friday's date
- Using DateFormat with locale causes FormatException: Trying to read yyyy from 2020-08-07 15:00 at position 0
- Convert local time (GMT+8) to UTC time
- Spark Window Functions - rangeBetween dates
- Convert between LocalDate and sql.Date
- Find total length of time in multiple values of a dataset that overlaps with a given period of time
- How to convert date to timestamp(DD-MON-YYYY HH24:MI:SS.FF format) in oracle?
- How to convert date to timestamp?
- Parsing dates with dart