Thanks Data Kruncher.
I have a julian date for the date an insurance claim was received. It is referred to as 'RCD' in the list of fields of my model. It is a 3 digit field. According to the reference guide, I should be able to convert this to a string date and it will assume the year is current. That's exactly what I want because these are all 2007 claims. But when I open the calculated fields window, name the field, set it as date/time, select conversion, and double click JulianToDate() I get this--> JulianToDate() with a blinking cursor between the parenthesis. I then go to the list of fields and double click RCD, which is a numeric field. It then looks like this JulianToDate(RCD). I hit okay and get an operand types error.
Aha! The old mixed data types problem...
The JulianToDate function requires a string field type input, so use the Str function to convert RCD from numeric into a string:
[font="courier"]JulianToDate(Str(RCD)) /font[/quote]will do the job for you.