Sunday, February 19, 2012

Format a Date field in the Regional Settings format.

Hi
How is it possible to format a date field according to the Regional Settings
Short (or Long) Date Format?
It seema that I can hard-code the format as dd/MM/yyyy (which is the date
format in my country), but dates formatted like that may be misleading if
the report is run by users of our software in other countries.
Thanks
Barry Flynn"Barry Flynn" <Anonymouse> a écrit dans le message de news:
uMbfBdR8HHA.1204@.TK2MSFTNGP03.phx.gbl...
> Hi
> How is it possible to format a date field according to the Regional
> Settings Short (or Long) Date Format?
> It seema that I can hard-code the format as dd/MM/yyyy (which is the date
> format in my country), but dates formatted like that may be misleading if
> the report is run by users of our software in other countries.
> Thanks
> Barry Flynn
>
>
You may have to deal with the Language Property of the report.
Patrick|||I'm a bit confused.
Maybe more than a bit... :)
I can see where I can set a Language property for a Table, or a TextBox.
(I can't see where to set it for the Report as a whole.)
But, setting such a property seems to me to be going in the wrong direction.
I want dates to display correctly no matter what country the report is being
run in.
How is setting a specific Language going to achieve that?
Thanks
Barry
"pi" <pisambert@.free.fr> wrote in message
news:%23oR5I6R8HHA.5980@.TK2MSFTNGP04.phx.gbl...
> "Barry Flynn" <Anonymouse> a écrit dans le message de news:
> uMbfBdR8HHA.1204@.TK2MSFTNGP03.phx.gbl...
>> Hi
>> How is it possible to format a date field according to the Regional
>> Settings Short (or Long) Date Format?
>> It seema that I can hard-code the format as dd/MM/yyyy (which is the date
>> format in my country), but dates formatted like that may be misleading if
>> the report is run by users of our software in other countries.
>> Thanks
>> Barry Flynn
>>
> You may have to deal with the Language Property of the report.
> Patrick
>

No comments:

Post a Comment