Date format in IDT

[former_member729889]

Hi,

I have an universe based on Teradata. I created a filter in IDT and it's like this :

@Select(Sales\Calendar Day) =  @Prompt('Date:','D',,Mono,)

When I use this filter and execute a test query in IDT, the date format is shown different in these 2:

Enter a value : 10.Feb.2015

Date : 10.Feb .2015 00:00:00

I formatted the Calendar Day dimension and I can see it as 'mm/dd/yyyy' in the report result. That's fine.

However, I want to do the same for the prompt screen in IDT too. How can I do this?

The requirement is, I use the same filter for SAP Lumira and it does not provide a calendar component for date selection.

So, the format of date to pass to universe is not clear.

Thank you!

[former_member4998]

Hi

Try to change the format Cal day using below options, and then check the filter date format is showing as per your requirement

predefined function TO_CHAR

Use the custom display format option.

Please find the below link for more info

[former_member729889]

Hi Dasari,

As far as I understand this is related to 'Date' part of the prompt.

Because I created a new dimension (CharDate) as you've suggested, however it still appears with timestamp in IDT.

@Select(CharDate) =  @Prompt('Date:','D',,Mono,)

[Former Member]

Hi Steve,

As you are using Date object, BO will by default add the timestamp as soon as you will choose any date from default Webi calendar.

In order to avoid timestamps on prompt window, you will have to edit ObjectFormat.xml file.

Below forum link might help you:

http://scn.sap.com/thread/3293713

NOTE: editing XML will only fix the issue in BI Launchpad and not at client tool level.

Regards,

Yuvraj

[former_member729889]

Hi Yuvraj,

Webi does not display timestamp, that part is fine for now.

Thank you!

[Former Member]

Hi Steve,

You may close the thread in case the issue is fixed.

Regards,

Yuvraj

[former_member729889]

What made you say that Yuvraj?