>Hello Friends,
>
>i have three fields in my table date , hour and minute. but instead of keeping three fields , i am more interested to keep single datetime field. but problem in datetime is if user does not enter time ,then it takes vfp's default time(midnight time). what i should do ? should i keep three fields separate?because hour and minute fields would be character and it requires validations for proper value
>thankyou
>john still

You can have separate textboxes (e.g. txtDate,txtHour,txtMinute) on data entry form, validate and concatenate values and keep them in one field.