>I have a program which scans a table and creates a new table from information listed in the first table. This program needs to calculate an expiration date which is six months from the validation date. I have tried something to this effect:
>
>exp_date = val_date + 180
>
>when this expression is put after a '?' command, the correct date is printed. However, when I try to store this in the database, all I get is ' / / '
>
>Any suggestions?
Craig
Check your data types. There is a BIG difference between Date & DateTime types.
HTH,
Tom