Date Format

Hi,
I have a report which display the data in a dataset and one of the column is
date type. The date format return by the dataset is in mm/dd/yyyy format,
and we have no rights to change the stored procedure which returning the
dataset.
I am not sure whether we can do some date formatting within the report
itself, with some scripting or formula.
Really appreciate your help.
ThanksBy Default, SQL RS has the flexibility to take the parameter as
DateString. That is from parameter side.
if you want to show the field formatted,Go to dataset properties >
fields > (here you can see all the fields) > add one field .Give the
VBExpression you want to play with.
after that run the dataset to preview
Hope this helps
Thank you
Raj Deep.A
On Apr 23, 4:19=A0pm, "Thalia Mei" <thalia...@.gmail.com> wrote:
> Hi,
> I have a report which display the data in a dataset and one of the column =is
> date type. The date format return by the dataset is in mm/dd/yyyy format,
> and we have no rights to change the stored procedure which returning the
> dataset.
> I am not sure whether we can do some date formatting within the report
> itself, with some scripting or formula.
> Really appreciate your help.
> Thanks