UserResponse() Function

building reports webintelligence
1

Hi All,

Can we modify UserResponse() function in such a way that if UserResponse(“Month”) is giving 'Aug ’ , we get the full month name August.

shukla :india: (BOB member since 2009-08-06)

2

Yes, we can. Use an If() or alerter.

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

3 
=FormatDate(ToDate("01/" + UserResponse([My Query];"Month:") +"/2009";"dd/MMM/yyyy");"Mmmm")

(the day of the month, and the year can just be hardcoded)

[Moderator Edit: Added code formatting - Jansi]

weaver (BOB member since 2008-10-17)

4

thanks :slight_smile:

shukla :india: (BOB member since 2009-08-06)