>>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


Actually, Tom, we both overthought the problem. I forgot to add "m." before the variable name. ;-<

Craig