Month & Year Drop Down Menu?

[Hackney]

I have a field that is:

Current length of continuous allocation of Care Co-ordinator. ( years and months )

Ideally I would like to have two drop down menus - one with years and one with months.

Would I have to have two fields in my table - one for years and one for months or can I have one?

Whats the best way?

Thanks.

 

[RuralGuy]

Do you have a StartDate and EndDate field? Can't you just calculate it when you need it? One field with the number of months would easily convert to Years and Months.

 

[Hackney]

They won't have an end date as they are current people.

Maybe I could just have a start date and calculate it from current date to start date.

But some clients maybe be seen by the team for a few months then 'closed' and then re-opened so they would have two start dates.

I just want the user to be able to enter the whole time a person has been seen by the team.

 

[RuralGuy]

It is always nice when the computer does all of the work for you. Without knowing more about your table structure I had in mind that no EndDate means still open so use today's date. If you put in EndDate information then I would let the computer add up all of the months and divide by 12 for years and Mod 12 for the remaining months.