Ok, this is what I have discovered, my dates are fine but everytime I put a code in grid1.column2.text1.interactivechange, I get the invalid date error.

What I trying to do is get the date entered in that column and pass it to an array. I am also checking the date was entered or not as follows:

&&grid1.column2.text1 is renamed as g1.c2.t2
with thisform
.x = recno()
if .x != .z
MESSAGEBOX('Please Re-enter CTO Date', 0, 'Update CTO')
.g1.c2.t2.value = {}
goto .z
.g1.c2.setfocus()
.refresh()
else
if empty(.g1.c2.t2.value)
MESSAGEBOX('Please Re-enter CTO Date', 0, 'Update CTO')
else
.a__gen10[.v,2] = .g1.c2.t2.value
if .z != .hldcount
goto .z+1
.g1.c1.setfocus()
else
.cmdedit.setfocus
endif
endif
endif
endwith

What gives?

Thanks
Nick Patel