i am tapping into an excel sheet as my database source. I have a settlement date column that is in MM/DD/YY format but when its pulled down into crystal reports it shows the date serial instead of the date format...and crystal thinks its a number so its not letting me change formatting to date. So I figure I could just use a formula field to convert the number to date format...i know you can do this with string, but how about numbers?
for string i know you can do the following:
how can I work this for numbers to date?