>i want to add a date like MM/YYYY
>i required this for expiry date of medician.
>
>warm regards,
>mk.
:-)))
Where is DAY portion? If you want just to add month and year in that format try this:
Add a TextBox in you form. Set its InputMask to: ##/####. In Valid/LostFocus Event or there wher you validate Entry Data put:
LOCAL lnMnt, lnYear
lnMnt = VAL(LEFT(thisform.TextBoxName.Value,2))
lnYear = VAL(RIGHT(thisform.TextBoxName.Value,4))
IF NOT BETWEEN(lnMnt, 1, 12)
MessageBox([Month number is not correct])
RETURN .f.
ENDIF
IF lnYear < 1900
MessageBox([Year number is not correct])
RETURN .f.
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.