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 does produce year-week but not in two digit format for the single digit weeks. Also, when I use this jmp formula I cannot use the generated year week in a graph as the Data Type is Expression. Any suggestions will be appreciated. Thank you.
