CamMac2 Posted March 21, 2005 Share Posted March 21, 2005 I have 2 date fields and a notes field that I have to combine with no slashes or dashes or othe marks (for export into another program) This is the format I need to export: mmddyy mmddyy note This is my calculation field Action Date & " " & FollowUp Date & " " & Action Notes This is how the field should look: 020904 021004 client seems to think there is no budget but this is the result I get 731620 731720 client seems to think there is no budget -------- I'm guessing that a date format uses some underlying numerical calculation, because I get a similar result in Excel if I change a "date" format to a Text format. I've tried DateToText, but I still have slashes (and no leading zeroes). If I import into Excel to "find and replace" the slashes, the "dates" changes to that underlying number code. Any ideas? It seemed like an easy problem, and would be, I guess, if the "date" format wasn't just a mask over other numbers. Thanks in advance Cheri Link to comment Share on other sites More sharing options...
This topic is 6579 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 account
Already have an account? Sign in here.Sign In Now