need a input mask for a 13th month or other possible solution

D

dakota

Can anyone suggest how I can do a mask for a fiscal year
that has 13th and possible 14th month fiscal years?
 
J

John Vinson

Can anyone suggest how I can do a mask for a fiscal year
that has 13th and possible 14th month fiscal years?
Click to expand...

I can't imagine doing this using a DateTime field - Undecember?
Dodecember?

I'd suggest storing the "date" as two fields, FiscalYear and
FiscalMonth, and concatenating them for display purposes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where to store the Fiscal (Tax) Month & Year data 2
Access 2 Digit year in Access Text Box 3
How do I expand a funtion's maximum character length? eg CUBESET 1
dynamic table 1
Group by fiscal months 5
Date Field - Input Mask? 1
Day/Month/Year as ##/AAA/#### 3
Input mask date syntax-limit input to a number range 2

Top