change date filed as per user login

[EArumugam]

Hi all,

I have a date fields in my query subject(start date,end date...)

and i have a user info query subject, in that i am having date format for the logged user.
for ex : if login date format is defined in that table like (dd-MON-yyyy) for my id.

now i want to change all the fields from table to user format.

i used below expression to change the date :to_char([start date],[user info].[date format])

i am getting sqlopen result-28 errror.

i used same expression for change the parameter date. (to_char(?p_fromdate?,[user info].[date format]), its working fine

but its not working for date field in the table.

please suggest.

thanks
eas