Robert Moran Posted April 25, 2011 Share Posted April 25, 2011 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 Link to comment Share on other sites More sharing options...
comment Posted April 25, 2011 Share Posted April 25, 2011 Try = 10000 * Year ( date ) + 100 * Month ( date ) + Day ( date ) This assumes no dates before Jan 1, 1000. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4750 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now