Hi Mr KenHigg..... please, what if I have 3 fields into 1 table, with NUMERIC data type: month, day, year...... but the month has only 1 digit....and I want to convert to date???
For exmaple, I have 28 - 9 - 2009 on the 3 numeric fields.
I have tried using cdate(mid,right,left) but does not work.....
What if I have Month: 10, Day:3, Year:2009?
Thanks in advance from COLOMBIA !!!!!