error message when trying to sort......
Hello Rose
This is an info-box field set to data type "date" the contents of the field is calculated from a date-picker field using this:
xs:date(DateRegistered) + xdt:yearMonthDuration("P1Y")
It is possible that some of the "date registered" data was imported at one point in the past.
The date format set on the DateRegistered field is YYYY-MM-DD. The same is used on the calculated field.
Hello Rose,
I'm not sure --- the application has evolved and it is possible that it was a different date format.
Here's what I found when exporting the records to excel:
4 of the records show the date like this:
12/1/2008
The rest of the records have the date in the correct format:
2009-04-30T17:00:00Z
So how do I change the 4 records to match? I've tried entering a new date into the field, but it doesn't change. Remember this field calculates the data using a regular expression (duration). I also tried using the Excel connector to make changes that way.
If you need to look in the application go ahead. Your name is still in the admin group as before.
Thanks,
Stephen
When clicking on the tab to sort records on a date field (collection "view"), the sort returns the following error:
Error: Invalid lexical value [err:FORG0001], :12:5
I'm using Windows XP and Firefox 2.0.
Note the date field I'm sorting on is a calculated field -- the contents are calculated with an expression.
All other fields in the view sort as expected. it is just the "expiry date" field that produces this error.