https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/492#M492 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? Fri, 29 May 2009 14:17:18 GMT kray 2009-05-29T14:17:18Z https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/492#M492 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? Fri, 29 May 2009 14:17:18 GMT https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/492#M492 kray 2009-05-29T14:17:18Z https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/493#M493 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)</img><BR /><BR />Cannot convert argument to a number [or matrix] 1 times At rows: {1} Operation: Date MDY, Date MDY(:MONTH, :DAY, :YEAR) Fri, 29 May 2009 14:42:15 GMT https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/493#M493 kray 2009-05-29T14:42:15Z https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/494#M494 Never mind... one of the columns was coded as "character", not "numeric". Duh! Fri, 29 May 2009 15:00:38 GMT https://community.jmp.com/t5/Discussions/Date-formula-not-working/m-p/494#M494 kray 2009-05-29T15:00:38Z