topic Re: Trouble formatting date from DMY to MDY in Discussions

Trouble formatting date from DMY to MDY

JMP_Student — Wed, 06 Jun 2018 17:09:45 GMT

Hi,

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!

Re: Trouble formatting date from DMY to MDY

twillkickers — Wed, 06 Jun 2018 18:43:30 GMT

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.

Re: Trouble formatting date from DMY to MDY

cwillden — Wed, 06 Jun 2018 19:04:08 GMT

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.