Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
Level I

Trouble formatting date from DMY to MDY



I'm using JMP 12 and trying to change my date column from d/m/y to m/d/y, but the format does not seem to be working. It just keeps the date as 04/06/2018 instead of changing it to 06/04/2018. Ultimately, I want to be able to use the date in m/d/y to convert it into the day of year. Is there any way to fix this issue or another way to change the date from d/m/y to m/d/y?


Thank you!

Level III

Re: Trouble formatting date from DMY to MDY

If you would like, you could create a formula column that reformats d/m/y to m/d/y. So in your "New Column" window, you would go to column properties, and select formula. Then you would use the formula

Format(Date, "d/m/y")

The new column will have the date formatted the way you want. Hope this helps.

Super User

Re: Trouble formatting date from DMY to MDY

There is a Day of Year() function and that does not require the data to be formatted in any specific way.  Underlying all date/time formats is an integer of the number of seconds elapsed since midnight, January 1, 1904.  All date/time functions in JMP work based on that underlying value.  However, it is curious that applying a different date format to the column has no effect.  Can you verify that toggling between m/d/y and d/m/y really does not change the table?  If that is the case, try restarting JMP.  If that doesn't help, you need to call JMP Tech Support.

-- Cameron Willden
Article Labels

    There are no labels assigned to this post.