Add months to date?

  • Follow


I have number field (value 1-12) and date field. How I can add that number
field to date field such that number sum months?


0
Reply S 1/5/2006 8:17:25 AM

I think you're looking at:
calcNewDate = Date((Month(DateField) + NumberField);
Day(DateField);Year(DateField)


G

0
Reply Grip 1/5/2006 4:19:11 PM


"Grip" <grip@cybermesa.com> kirjoitti viestiss�
news:1136477951.879294.73940@g44g2000cwa.googlegroups.com...
> I think you're looking at:
> calcNewDate = Date((Month(DateField) + NumberField);
> Day(DateField);Year(DateField)
>
>
> G

Thanks!! It works great. Grip: you are the king.


0
Reply S 1/9/2006 6:20:35 AM

2 Replies
897 Views

(page loaded in 0.056 seconds)

Similiar Articles:













7/23/2012 9:59:56 PM


Reply: