LoneReaper Posted March 19, 2004 Share Posted March 19, 2004 i would like a calulated field called "RW_dateentered" to convert a field called "HB_dateadded" like in the subject. i tried Right( DateAdded , 4 ) & "-" & Middle( DateAdded, "3" , 2 ) & "-" & Left( DateAdded , 2 ) but it doesnt work. any ideas? Link to comment Share on other sites More sharing options...
kiwiora Posted March 19, 2004 Share Posted March 19, 2004 I'm not sure about swapping the format of them around, except for altering the display via custom date display. I have found to convert / to - you could try substitute command (Substitute({fieldname},"/","-")) Link to comment Share on other sites More sharing options...
-Queue- Posted March 19, 2004 Share Posted March 19, 2004 Make your calculation field a text result if you want to use a nonstandard date format for exporting to another type of db, etc. Link to comment Share on other sites More sharing options...
BobWeaver Posted March 19, 2004 Share Posted March 19, 2004 Assuming that DateAdded is a date field and not a text field..... Option 1: You can just custom format the date field to display yyyy-mm-dd. Plunk the DateAdded field onto your layout and select the date options in the format menu. Option 2: If you want to do it the hard way, then you can use this formula: Year(DateAdded)&"-"&Month(DateAdded),&"-"&Day(DateAdded) The calculation result should be set to text. Link to comment Share on other sites More sharing options...
LoneReaper Posted March 19, 2004 Author Share Posted March 19, 2004 Thanks Guys! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7315 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