Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: Convert Numeric to Date

    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?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Convert Numeric to Date

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

    Cheers
    Sathyaram

    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?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •