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.
- how to sort a sequence of numbers treating them as a date but without zeros
- Whats the point of Locale in DateTimeFormatter?
- Get mySQL MONTH() to use leading zeros?
- What is this date format? 2011-08-12T20:17:46.384Z
- Iterating through a range of dates in Python
- How to subtract two java.sql.Date dates?
- How to add months to a date in JavaScript?
- Displaying the build date
- How to correctly join two tables that each have Start Date and Stop Date columns?
- Why does Date() and Calendar.current.startOfDay(for: Date()) produce different days?
- Converting Excel Date Serial Number to Date using Javascript
- Convert date to datetime in Python
- Format date as dd/MM/yyyy using pipes
- Converting Date to epoch milliseconds
- HIVE SQL script to set end date to 12-31 of current year
- Is there a way to count number of ISO weeks in a given year using Moment.js?
- How can I modify this script to select any folders dated in the last 12 months?
- Find first Monday of given month or last Monday of previous month
- Why is Date behaving quirkily in JSON.stringify replacer?
- Uncaught TypeError: Cannot read property 'split' of undefined
- Sort List of Tuples by Date element
- get last three month records from table
- set the end date based on start date in the html input field using js
- Convert an array of datetimes into a comma-separated string of hyphenated range expressions
- Convert ZonedDateTime to java.util.Date
- Get number of days for previous month
- How to convert to Date format like 'January 2024' in T-SQL?
- FIRST and LAST VALUE bringing conflicting row quantities in the same query. WHY?
- Month and Year picker in Material UI React
- SAS proc import imports date with dots at random place. How can I solve this problem?