I have written this code for a command button TOOLTIPTEXT property:

=cdow(date)()+','+mdy(date)()

and I get the following:
Thursday , July 23 , 98

I don't get the century as 1998.
Do I have to SET CENTURY ON ?
And if I do then where.......in the forms init event or the command button's event?

Now this result made me more ambitious and I tried to write this code in the Grid's ToolTipText property:

=reccount(mytable)

to get the number of records in the grid , but it showed nothing.Can this be done ? The Data Environment table has the mytable in it.And the form opens with mytable opened in the grid.What am I doing wrong ?

Also the grid has a date textbox.What I want to do is whenever the user places the mouse cursor on a particular record in the date textbox , the day i.e. Monday etc , is shown in the ToolTips.
Thank You All
Zaraq