AnsweredAssumed Answered

HELP! Booking No defined by calculations

Question asked by Shoreline on Apr 20, 2010
Latest reply on Apr 21, 2010 by Shoreline

Title

HELP! Booking No defined by calculations

Post

I have to create a booking no that is made up of various calculations

 

It has to display as follow : eg. 1004-0001 (YYMM-SerialNo) only problem is that the month part displays as "01"

 

This is the calculation step1

Booking_Year & Booking_Month & " - " & Booking_Serial

 

The year part of my calculation was easy step2

Case(

Year ( 2010 ); "10";
Year ( 2011 ); "11";
Year ( 2012 ); "12";
Year ( 2013 ); "13";
Year ( 2014 ); "14";
)

 

But the month doesn't want to work the same way, tried diffrent ways step3

Case(

MonthNameJ ("January"); "01";
MonthNameJ ("February"); "02";
MonthNameJ ("March"); "03";
MonthName ("April"); "04";
MonthName ("May"); "05";
Month ("June"); "06";
Month ("July"); "07";
Month ("August"); "08";
Month ("September"); "09";
Month ("October"); "10";
Month ("November"); "11";
Month ("December"); "12";
)

 

Is there another way of doing this?

 








Outcomes