This content has been marked as final. Show 6 replies
but i want to convert it in mm/dd/yyyy at report level.
What do you mean by this?
To be shown on pages?
To be shown in BI Publisher reports?
To be shown in PSQuery?
etc, etc, ...
Easiest way to set this via
Main Menu > My Personalizations > Regional Settings and change Set Date Format. No customization required.
I think this is initially also bound to the Regional Settings of the (Windows) Workstation
i want this in report to do.
in report date is not coming in required format so
can we do some casting on it to get it.
to you mean BI Publisher reports?
In that case add the date field to you template, right click on the field, select properties. Set type to date and set format to desired format eg mm/dd/yyyy
i cant set the column properties since data type of column is char.
can we do something in edit formula of column since i want it at answer.