Converting a number to a date 1

[mrshardee2]

I have a number field that I am pulling into a report from an AS400 database. The field is 3-4 digits for the month and day (Jan 14 = 114, Nov 23 = 1123). How can I convert this to a date field in CR 8.5 for reporting purposes. It seems like it should be so easy...

Probably will be for you seasoned reporters!

Thanks!
Amber

 

[lbass]

To make it a data type of date, you would also need a year field. In the following, I've hard-coded the year to 2004, so if you have a year field, you would substitute that for "2004":

date(2004,val(left(totext({table.number},"0000"),2)),
val(right(totext({table.number},"0000"),2)))

Substitute your actual field name for {table.number}.

-LB

 

[mrshardee2]

I can't have a year in the report for this field. I'm trying to list employee birthdays and mgmt. wants the year excluded. Any other suggestions?

Amber

 

[mrshardee2]

I've got it! Your coding worked and I just formatted the date without the year. Thanks!

Amber