Convert number elements to date

[pl1101]

I have 3 date elements that are number datatypes. The year is a number like 1,2,3...95, 98,99. Can you help me convert to a date? day and month are the same datatype as year.

 

[Madawc]

Use

Date (YYYY, MM, DD)

The year, month and day can be database fields or formula fields that you create.

You'll probably need to put a prefix to the year number, 20 or 19. I'd suppose anything greater than 11 would need the 19 prefix.

PS. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.


Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

date(2000+{table.year},{table.month},{table.day})

If the year could be earlier than 2000 you would have to explain how you know that--what the rule is. Then you would replace the year part of the formula (2000+{table.year}) with a formula like this, for example:

//{@year}:
if {table.year} > 20 then
1900+{table.year} else
2000+{table.year}

-LB