>how can i show date names in grid headers ?
>for eg i have a table named january when i add this table to DE on the form and setup recordsource of grid . headers should change at runtime like under ( when i run the form)
>How can i do this ?
>
>Monday 17.02.2003|Tuesday 18.02.2003|Wednesday 19.02.2003
>
>PS: | is separator of grid headers
>
>TIA
with thisform.myGrid
for each oColumn in .Columns
eExpression = ...
oColumn.Header1.Caption = eExpression
endfor
endwith
eExpression is some expression that would give the string you want. ie:
if your fieldnames are like _20030201, _20030202 :
lddate = ctod(transform(;
substr(justext(.controlsource),2),'@r ^9999/99/99'))
oColumn.Header1.Caption = cdow(lddate)+' '+dtoc(lddate)
Cetin