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