This content has been marked as final. Show 6 replies
Are you sure you're not thinking about the date format you used when typing in dates at runtime? The OPM Help specifies that you must use the format yyy-MM-dd for rule authoring, so I'm surprised if the rules worked using any other format in the rule authoring.
See this article: Formatting of attribute values http://docs.oracle.com/html/E38269_01/Content/Reference/Formatting_of_attribute_values.htm (section: Unformatted attribute values): "Unformatted values are used... for any date, date/time or time values used when writing rules in Word or Excel (eg constants, values used in comparisons)". Then in the table in that section it says for date attributes the form is yyyy-MM-dd and gives the example 2007-10-25.
Jasmine, you are right 31-09-2011 is a wrong date, I just typed any date as an example and didn't realize that it is an impossible date . We use many dates in Excel in a format dd-MM-yyyy (we do not type in date in runtime).
In the link you have sent it says that "Formatted attribute values based on rulebase region are used".
" if your region was set to the United States you would see the following: MM-dd-yy"
"Region set to Australia, which includes the date format dd/MM/yy
Region in our project is set to United Kingdom so the date format should be dd-MM-yyyy.
I have checked that OPM Project Properties Language is set to English (UK) so it should be fine.
The strange thing is that it works fine on other laptops - the date 03-09-2011 is red as 3 September 2011, but on my laptop it is red as 9 March 2011.
When it comes to read the date 30-09-2011, on other laptops is red as 30 September 2011, but on mine cannot make a date as there is no month number 30 so it throws the error "Cannot perform comparison expression on right expression with type number"... What actually happens is that on my laptop OPM reads the dates from Excel in American format.
As I wrote earlier, It was working fine at my laptop as well before reinstalling Windows. I had this problem long time ago again but I was able to resolve it by changing language,region settings in Windows I think.
Now it seems like I have got the same language,region settings in Windows as I had before, my colleagues got the same language, region settings on their machines as well.
Iit seems like dd/MM/yyyy is red fine (UK format), but the format dd-MM-yyyy is red in American format...
What settings should be set in Windows or Excel or maybe somewhere else OPM to read the date from Excel in English UK format dd-MM-yyyy?