How to remove Time stamp

[Former Member]

Hi Gurus

I am using webi 3.1 and using Infocube universe

My problem is when i select calendar date i am able to display time stamp along with date in query prompt (12/02/2011 12:00:00)(MM/dd/yyyy hh:mm;ss)

i dont want to show the time stamp in query prompt as my users dislike to see that timestamp .

I thought In universe we can do it . But i searched the forums related to this but did not found .please help in this . i would appreciate ur efforts

Thanks & regards

Sunil

[Former Member · Accepted solution]

hey

sunil kumar!!!!

Did you solve this problem? I be suffering from the same problem. T.T

If you've ever solved, please tell me how to remove Time stamp.!!!!!!!!!

[former_member207878 · Accepted solution]

Try with below formula:

=Substr(UserResponse("Date:");1;10)

[Former Member · Accepted solution]

Hi sahill khurana

I am using webi 4.0

My problem is when i select calendar date(input Controls) i am able to display time stamp along with date in input Controls(MM/dd/yyyy 12:00:00 AM)

i want to see  (MM/dd/yyyy)  (not (MM/dd/yyyy 12:00:00 AM) )), when i select calendar date(input Controls)

where is the calendar date(input Controls)' format setting??

i dont want to show the time stamp in calendar date(input Controls) as my users dislike to see that timestamp .

Thanks & regards

[former_member207878 · Accepted solution]

Yongho,

Create a variable say InputDate with below formula:

=FormatDate([date_object];"MM/dd/yyyy")

And use that variable(InputDate) for Input Control, then you will not see any timestamp in input control.

Try it and let us know if you face any issues.

[Former Member · Accepted solution]

hey sahil khurana

I create a variable say InputDate with below formula:

(=FormatDate([date_object];"MM/dd/yyyy") )

And use that variable(InputDate) for Input Control, then you will not see any timestamp in input control.

but InputDate's input control is not  Calendar because FormatDate()'s output is string type

so I tryed variable say InputDate with below formula:

Todate(FormatDate([date_object];"yyyy-MM-dd"); "yyyy-MM-dd")

I want to use calendar Input controls..

if i select date in inpu controls(calendar),...

The results are now out of the picture below.

However, when the date was selected, I want the results below.

i know that the 12:00:00 AM  is default values, so ..when I select a date, I do not want to show 12:00:00AM.

[Former Member · Accepted solution]

Hi park

Which data base you are using , this formatting  depends on DB , suppose we take Sybase db , we can use the dataformat function in the data object to get the desired output,  i suggest you to search the function for date format corresponding to your db and apply the same in universe level  

and also try this

At Universe level goto business layer , double click on date object and goto to advanced properties and lower left side select the format you wud like to view , some times it might work ..that too depends on db

Hope this helps u

Sunil

[Former Member · Accepted solution]

Hi Yongho,

Create a variable to derive month/date/year from calendar object and use it as filter/Input control.

=todate([Object];"mm/dd/yyyy")

Regards,

Madhu

[Former Member · Accepted solution]

Hi Sunil,

I tried your below mentioned comments...

"Which data base you are using , this formatting  depends on DB , suppose we take Sybase db , we can use the dataformat function in the data object to get the desired output,  i suggest you to search the function for date format corresponding to your db and apply the same in universe level 

and also try this

At Universe level goto business layer , double click on date object and goto to advanced properties and lower left side select the format you wud like to view , some times it might work ..that too depends on db "

I am using Universe 3.1 and it is connect to the "DATA MART" I tried this option on the Object advanced Properties but it is not changing. I am still getting the Time Stamp in the Prompt Query.

I can able to change the format in the report level, but I am unable to changes in the Prompt Query Filter...!!

Please help..!!