Hi All,
I am getting an error when trying to enter a date value in a matrix. I run a query which has a string field and date field as the result. I now want to add the 2 columns as a new line in the matrix. The first column adds fine, but on the second column I get an exception Data Source - Bad Date. How do I set the value of an edit text to a date value from a query?
My code:
oEdit = oMatrix.Columns.Item("c_Start").Cells.Item(1).Specific
oEdit.Value = oRecord.Fields.Item(1).Value
The error also definately occurs on the second line of my code.
I have read the posts
Display UserDataSource date format
and
but they haven't solved the problem
Thanks in advance,
Adele.