BO 3.1 Remove timestamp from date calendar in prompt box.

[Former Member]

I have used trunc function in universe object to create this prompt. I donot want the timestamp with date when I select from the calendar. and also I donot want to remove the timestamp from the LOV's. Userresponse is also showing on the report. I have used the syntax in the cell to remove the timestamp in the report.

Let me know if you have solution to this. If any question arises please let me know I will be happy to explain on the logic.

Regards,

Amais

[former_member207878]

Amais,

Can you please check below link, if ti helps:

http://www.forumtopics.com/busobj/viewtopic.php?p=628947&sid=a6dffd86c651cd070aac2649459b25a4

[Former Member]

Thanks for reply Sahil.

If I am not wrong if we change the prm file it will affect other date objects as well which I dont want because we eant to se the timestamp on the report. and for that I have another object.

[former_member182342]

Hi Amais Qureshi,

    Actually this issue has been identified as a product defedt in BI4.0 and is not yet fixed.

Please refer to KBA:

https://service.sap.com/sap/support/notes/1609385

Also please check below link

https://scn.sap.com/thread/3321918

Regards,

Anish

[Former Member]

Thanks for the reply Anish. Let me know if you have any work around for this. Like if we can change the default timestamp from 12:00 am to 11:59 pm.

Regards,

Amais

[former_member182342]

Hi Amais Qureshi,

Check the below link it might be help you:

http://scn.sap.com/message/13818992#13818992

Regards,

Anish

[Former Member]

Thanks Anish. But that link has IDT reference and I am using 3.1.