3 Replies Latest reply on Jul 19, 2010 2:34 PM by philmodjunk

# How to format a number as a position?

### Title

How to format a number as a position?

### Post

I need to print a certificate to format a date (July 4, 2010) as

"Printed this Fourth day of July, Two Thousand Ten."

Any ideas?

Thanks!

lr23

• ###### 1. Re: How to format a number as a position?

I'd set up three fields for this that all extract different parts of the current date:

cDayNumb: Let ( d = Day ( get ( currentdate ) ) ;
Case ( d = 1 ; "First" ;
d = 2 ; "Second" ;
d = 3 ; " Third" ;
//and so forth
"Thirtyfirst" ) )

cMonth : MonthName ( Get ( CurrentDate ) )

cYear: "Two Thousand " & Let ( y = Year ( Get ( CurrentDate ) ) ;
Case ( y = 2010 ; "Ten" ;
y = 2011 ; "Eleven" ;
// and so forth ))

Once you have these three parts working for you, you can either define a third calculation field that combines them or you can insert these as merge fields into layout text to get your full sentence.

• ###### 2. Re: How to format a number as a position?

Super!  Thanks!

• ###### 3. Re: How to format a number as a position?

There's also a knowledgebase article that shows how to convert nearly any number into word form that could be adapted for this, though it seemed like overkill for this specific use.