date output format

Hi,

I have the following problem.

I have made a parametered report where i ask a begin date (@.datefrom) and an end date (@.dateto).

when i enter my dates via the little calendar is see the format dd/mm/yyyy

When i do a preview of report i have a textbox with the following expression :

="Total work time from " & Parameters!DateFrom.Value & " to " & Parameters!DateTo.Value

but the output of the date format is mm/dd/yyyy.

What can i do to have the output format dd/mm/yyyy

Vincent

Hi Vincent,

Try to use

="Total work time from " & CDATE(Parameters!DateFrom.Value).ToString("dd/MM/yyyy") & " to " & CDATE(Parameters!DateTo.Value).ToString("dd/MM/yyyy")

|||

Hi,

Thanks for the quick response.

This works great.

Greetings

Vincent