365267_en-US

liliconcom

week start date

Hi, I have a column transaction date and need to transform it to the date of Monday in that week. I figured out the below formula and could reach to the right date I need. However it automatically became a character format and no matter how many times i switch it to nominal format it kept changing back to character. Does anyone know why? Thank you!

 

 

AnalyticsData TableRe: week start date

The Short Date() function returns a character string which formats a date or datetime value into m/d/y format.

 

If you want a JMP date value just remove the Short Date() and then set the format on the column to m/d/y.

 

Hint: Use the peel button  to remove the outer function from a selection in the Formula Editor.

 

More here: Using dates, times, datetimes and durations in JMP 

Re: week start date

Hi @joann , it is because the function Short Date is specified to return a character string,

see documentation library as attached.

So you should leave away that function to keep it a date, and use the column format instead to control its look.

 

 

Re: week start date

Thank you Jeff! The peel button is a new thing to me. 

I have one following question- after removing the short date function I put the new week date into tabulate, but it somehow show the same date multiple times while usually it will show unique dates, as below screenshot. Not sure why the reason. One possible thing i can think of is that the original date column that i used to create this new week start date, has format like "2018/01/01 12:13:05 AM". Do you know a way to fix the tabulate? Thank you!

 

 

Re: week start dateThank you Georg! I have one following question about this column, could you check the above? Thank you.Re: week start date

You could create a formula where you remove hours, minutes and seconds from the date you have:

Names Default To Here(1);
dateToday = Today();
Show(As Date(dateToday));
dateToday_noSeconds = dateToday - TimeOfDay(dateToday);
Show(As Date(dateToday_noSeconds));

Or directly with JMP (right click column name -> New Formula Column -> Date Time -> Date):