Topic
  • 2 replies
  • Latest Post - ‏2009-01-07T20:57:15Z by SystemAdmin
SystemAdmin
SystemAdmin
250 Posts

Pinned topic How to pass date in text box prompt as DDMMMYY format

‏2009-01-07T20:57:15Z |
Yetchina Hemasundar said:

Hi

I have to enter date in text box format as DDMMMYY format.

But my database ( Teradata ) it is DD/MM/YYYY format.

E.g: Promt Date: 27OCT08

Database Date: 27/10/2008

I don't know how to pass date ( DDMMMYY format ) in text box prompt.

Appreciate if you help me.....

Regards,

Sundar.

Updated on 2009-01-07T20:57:15Z at 2009-01-07T20:57:15Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    250 Posts

    Re: How to pass date in text box prompt as DDMMMYY format

    ‏2009-01-07T20:57:15Z  
    Suraj Neupane said:

    You can use 2007-01-22 format and then change the teradata date to cognos date while filtering.

    For example;

    cast(teradata date, date) = cast(?prompt date?,date)

  • SystemAdmin
    SystemAdmin
    250 Posts

    Re: How to pass date in text box prompt as DDMMMYY format

    ‏2009-01-07T20:57:15Z  
    Eugeny Shubin said:

    Strange!!!

    1) Why dont you use simple date prompt?

    2) It's not best practise to use text values for date. How you'll control data? You'll need sophisticated parser!

    Updated on 2009-01-07T20:57:15Z at 2009-01-07T20:57:15Z by SystemAdmin