Format date yymm based on number of months.

[mrenshaw]

I am importing data to a program that requires the life of an item. This is in months such as 241 months. The valid format for this program is YYMM. 241 = 2001 or 20 years 01 month.

Another example: 16 months should read 0104 or one year 4 months.

Any idea how to convert this to yymm format based on the number of months?

thanks in advance.

 

[Jon K]

Format([NumberOfMonths]\12, "00") & Format([NumberOfMonths] Mod 12, "00")
.

 

[mrenshaw]

Thanks

Thanks Jon, works perfect!! I didn’t have a clue about Mod 12. Very much appreciated.

 

[namliam]

Mod returns whats left over after the devision...

13 mod 12 returns 1 for 13 - (1*12) = 1

26 mod 12 returns 2 for 26 - (2*12) = 2

Get it?

 

[mrenshaw]

Got it! Thanks for the info namliam. Thank you both for your time. Very much appreciated.