Convert Numeric to Date

LindaHarvey · #1 (**permalink**) 01-14-04, 19:20

Cognos Impromptu has a function called MOD which converts a numeric field to date.

We have a field which is essentially a time key (8 dec) but to convert it to date - at the moment is a costly exercise where we convert numeric - to character and substring to certain positions 3 times and then concatenate these 3 times.

Does anyone have any suggestions?

sathyaram_s · #2 (**permalink**) 01-14-04, 19:24

It would be nice to have an example of what you are doing now!

Cheers
Sathyaram

Quote:

Originally posted by LindaHarvey
Cognos Impromptu has a function called MOD which converts a numeric field to date.

We have a field which is essentially a time key (8 dec) but to convert it to date - at the moment is a costly exercise where we convert numeric - to character and substring to certain positions 3 times and then concatenate these 3 times.

Does anyone have any suggestions?

Internet Services

Web Development

Digital Marketing

Consumer Tech