DateAdd(interval, number, date)..Pls help

[bnath001]

Hi,

I am using VB5. I am using DateAdd(interval, number, date)
function. In the interval parameter I need to use half year (6 months). But in the help I don't find that interval. The intervals has quarter, month, seconds, hours, days but not Half year . Can some one give me some idea how to implement this please.


thank you
nath

 

[strongm]

You've almost managed to answer the question yourself, without realising it. A half year is 6 months, as you note - so just use DateAdd with an interval of months, and use 6 of them:

DateAdd(&quot;m&quot;,6,<whatever_date>)