Format date in Webi

[abhimanyu_sharma]

Hi Experts,

I have a prompt "Transaction Period" in which user are giving values like - 5/1/2014 - 5/5/2014.

I need to show the end date which is 5/5/2014 as the column in the Webi Report.

I used user response function but i am getting the result like :

5/1/2014 12:00:00 Am;5/5/2014 12:00:00 Am

I need like this - 5/5/2014

[Former Member · Accepted solution]

Will you always get the user response output in the given format - 5/1/2014 12:00:00 Am; 5/5/2014 12:00:00 Am ?

Then you can use Pos() and SubStr() functions to get the end date

[saurabh_sonawane]

enddate=Substr([con];Pos([con];";")+1;Pos([con];" "))

its work i had try now

[former_member4998]

Hi..

You can use TO_CHAR function....You can change required format @ Universe level using the Create Display Format option. Please find the below link.

BI4.1 Business Layer Enhancements - Create Display Format

[saurabh_sonawane]

use funcation TODATE()

[saurabh_sonawane]

TOdate(var,"dd/MM/YYYY")

or u can change the format also by right click on the column and select date format which u want to display

[saurabh_sonawane]

check this

[abhimanyu_sharma]

hi Saurabh

my queston is to show the end date of the variable.

TOdate(var,"dd/MM/YYYY") - this will only convert the format.

[saurabh_sonawane]

todate(userresponse("enddate"),"dd/MM/YYYY")

[Former Member]

Hi Abhi,

Transaction Period object will display the list of prompt values,so

you can try max function on Transaction Period object,it will display the end date.

Regards,

Samatha B