Damon Ostrander or Anyone - Using to textboxes and formulas
Posted by Beverley B on October 31, 2001 7:58 AM
let me explain first. If our 2002 financial year starts in october 2001, the period i would use for october would be 0201 - 02 would be the year and 01 the month. what i want to do is to use the month and year which are in 2 textboxes to form a period in a third textbox can this be done.
month textbox1 = 12 (december)this is 3rd month in finanacial year
year textbox2 = 01 (2001)
I want to write code including a formula to calculate the period which would be 0203.
Can anyone help me with this???