Get Date as Text

[Robert Moran]

I am using the get as text calc field to convert a date filed to text. I can do the order part without a problem but don't know how to put the leading character 0 in for single digit months and days. The date and date as text order is CCYYMMDD but the get as text returns, for example, 201144 while the custom set up for date does 20110404, the format I need to dump into a legacy system. Any help would be great.

Bob Moran

[comment]

Try =

10000 * Year ( date ) + 100 * Month ( date ) + Day ( date )

This assumes no dates before Jan 1, 1000.