good day to the experts
i never use a blank date field since, but this time i was asked by my client that a blank date field should be shown if there is no payment made.
in vfp there is no problem, but when i saved it from vfp record to ms sql2000 record, when i refresh the form and or open the table at ms sql server the blank date field has already a date added in blank field "01/01/1900" is vfp has nothing to do with it?
thanks for any help regarding this matter
Simply you can have a comparitive date & Empty date like the below
store ctod(' / / ') to Null_Date,Disp_date
store ctod('01/01/1900') to Comp_date
if MyTable.Date_Field=Comp_date then