Get "Months Between" using only Months and Years

...rather than using a full date string.

[neophyte]

Hello All -

I'm planning a form that takes Work History detail. Of course two of fields in this form are "From" and "To". For this project, the client doesn't need to know the "From" Day, or the "To" Day. He just wants to capture from "2003-07" to "2006-09" for example.

My problem is, without using the entire date string "2003-07-07 / 2006-09-01" how does one go about accurately determining the number of months between the two year/month pairs? Is this possible, or do I have to capture the full date?

Neophyte

[mikeyb]

Hi,

How about always using the 1st day of the month?
You won't need to capture/store the day, but just use it for the calculation.
2003-07-01 / 2006-09-01

Mike