date

[The ScareCrow]

Because of the convert function in the query I'm assuming your using sql server

Research the DATEDIFF function

Ken

[Aubyone]

I am using the .net calander control and it return the date in MM/DD/YY.
Where the server is setup DD/MM/YY.

Can am one tell me why date would come out diiferent to the server regional
seting?

Where does the it get the date format from and how can I force it to be
DD/MM/YY format?

[Jules]

hi there

i suggess you have a look at this link

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemGlobalizationDateTimeFormatInfoClassTop ic.asp[/url]

you can also have a look at

[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandarddatetimeformatstrings.asp[/url]

it's an example on how to set your own dateformat.

if it doesnt help, please let me know.

Jules





"Aubyone" <Aubyone@discussions.microsoft.com> wrote in message
news:9E5550D5-8D10-4AFA-AF3E-91EF99C4B037@microsoft.com...

>I am using the .net calander control and it return the date in MM/DD/YY.
> Where the server is setup DD/MM/YY.
>
> Can am one tell me why date would come out diiferent to the server
> regional
> seting?
>
> Where does the it get the date format from and how can I force it to be
> DD/MM/YY format?
>
>

[Aubyone]

Thanks

The worry date format was being used it the app finally all the date setting
were changed in regedit, happily this worked so did not have to force the
date format in the app.

But thanks for article links they were interesting and may be helpfully it
the further.

"Jules" wrote:

> hi there
>
> i suggess you have a look at this link
>
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemGlobalizationDateTimeFormatInfoClassTop ic.asp[/url]
>
> you can also have a look at
>
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconstandarddatetimeformatstrings.asp[/url]
>
> it's an example on how to set your own dateformat.
>
> if it doesnt help, please let me know.
>
> Jules
>
>
>
>
>
> "Aubyone" <Aubyone@discussions.microsoft.com> wrote in message
> news:9E5550D5-8D10-4AFA-AF3E-91EF99C4B037@microsoft.com...

> >I am using the .net calander control and it return the date in MM/DD/YY.
> > Where the server is setup DD/MM/YY.
> >
> > Can am one tell me why date would come out diiferent to the server
> > regional
> > seting?
> >
> > Where does the it get the date format from and how can I force it to be
> > DD/MM/YY format?
> >
> >

>
>
>