492_en-US

liliconcom

Date formula not workingWhat could cause the Date function to not fill the column. I have three tables, one of which the Date Time : Date (MDY) worked just fine. In the other two tables however, after selecting the proper table columns (MONTH, DAY, YEAR), no date data filled the column. This seems so simple that I am rather perplexed. Ideas?Re: Date formula not workingNever mind... one of the columns was coded as "character", not "numeric". Duh!Re: Date formula not workingMore info. I am using jmp 8 for OS X, I tried opening the table with jmp 7 and got following error (which did not appear in jmp 8)

Cannot convert argument to a number [or matrix] 1 times At rows: {1} Operation: Date MDY, Date MDY(:MONTH, :DAY, :YEAR)