>>>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
Whats this 'WE' stuff Kingmosobee? (BG)
Tom