Add months to date?

#1

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?

#2

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

G

#3

"Grip" <grip (AT) cybermesa (DOT) com> kirjoitti viestissä
news:1136477951.879294.73940 (AT) g44g2000cwa (DOT) googlegroups.com...

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.filemaker comp.databases.filemaker