Formating a Leading Character on Day and Month

[rudym88]

Hi all,

I created a script to auto save a record and using a field Date in the filename, it works find with the exception that if the day or month on contains one digit i cant figure out how to add the leading zero. Any ideas would be great.

This is the formula I am using on a Variable

Set Variable [$Date; Value:Month ( Service Ticket::TicketDate ) & "-" & Day ( Service Ticket::TicketDate ) & "-" & Year ( Service Ticket::TicketDate )

RudyM

[Vaughan]

Right( "0" & Day( TicketDate ) ; 2 )

[rudym88]

Thanks Vaughan works like a charm

Thanks

RudyM