JMP 16 Useable Year Week Column
I am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is in yyyy-ww format with a two digit week. When I add a new column and try concatenating Year & Week (Year( :Date ) || Week Of Year( :Date )) it doesn't allow me to concatenate the "-". If I forego the "-" it do...