Date format

building reports desktopintelligence
1

hello all,
i am using UserResponse(“Enter Date:”) function in a report. date format is M/D/YYYY HH:MM:SS AM/PM(10/6/2009 12:00:00 AM)
How to display the date format into 10/06/2009
I am able to do this in webi. But not getting in Deski.

kiwi (BOB member since 2009-06-17)

2

Try this.

=FormatDate(ToDate(UserResponse("Enter Date:"),"mm/dd/yyyy hh:mm:ss a"),"mm/dd/yyyy")

Jansi :india: (BOB member since 2008-05-12)

3

Tried but not worked. Also I tried with the below but not worked.Can you suggest me on this.
=Formatdate(ToDate(UserResponse(“Query 1 with Business_Details”,“Enter Date:”);“M/d/yyyy hh:mm:ss a”);“MM/dd/yyyy”)

kiwi (BOB member since 2009-06-17)

4

If you just want to display then you can use SubStr() function.

SubStr(UserResponse("Enter Date:"),1,INSTR(UserResponse("Enter Date:")," ",1)-1)

Rakesh_K :india: (BOB member since 2007-12-11)

5

“Not Worked” is not a very helpful description. Can you expand on that?

pablolee :uk: (BOB member since 2008-07-29)