Skip to Content
0
Former Member
Sep 14, 2005 at 08:45 AM

Enter date in matrix

546 Views

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

Data Source - Bad Date

but they haven't solved the problem

Thanks in advance,

Adele.