Jump to content

convert mm/dd/yyyy to yyyy-mm-dd


This topic is 7315 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.