Subscribe Bookmark RSS Feed

Date formula not working

kray

Community Trekker

Joined:

Jun 23, 2011

What 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?
2 REPLIES
kray

Community Trekker

Joined:

Jun 23, 2011

More 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)
kray

Community Trekker

Joined:

Jun 23, 2011

Never mind... one of the columns was coded as "character", not "numeric". Duh!