AnsweredAssumed Answered

New User - Need Calculation for Serial # with date.

Question asked by j.lewis.photo on Feb 19, 2009
Latest reply on Feb 19, 2009 by j.lewis.photo

Title

New User - Need Calculation for Serial # with date.

Post

I have a photography business and I use FM for managing estimates/invoices mainly. I'd like to have each new record automatically generate an index number, which I would in turn use to label my photo jobs. This way when I need to find images from a job from last year, I find it in FM, then use that number to find the images on my computer.

 

I'd like the the index # to be something like this...  09020001

The 09 is for the year (2009), the 02 is for the month (February), and the 0001 is a 4-digit serial #.

 

Can someone give me the calculation for this? I've been using FM for a couple years, but have only recently began developing custom layouts. So my level of experience in this is definately as an amateur, just an FYI. 

 

Thank you for any help. 

Outcomes