Expert: David Oldfield - 2/25/2002

Question
Hi,


This is John from South India.

I got an interesting Question for You.Can you suggest me about How to change Date/Time format settings in Control Panel using VB.

The reason for this question is I tried to insert a record in MS-SQL Server thru' VB.But I face a regular problem of invalid Date format/ even data inserted in a different format,even after I use FORMAT(DATE,"dd-mm-yy").

Hope I will get an interesting reply on this about How to change Date/ Time Formats in Control Panel thru' VB.

Regards,

John .D. Prabhakar

Answer
I believe any (or all) of these functions should work, debending on what version of vb you are using...

formatDateTime(intNamedFormat, date())
cDate(date()) ' This one will convert in expression to a date... which will be compatable w/ sql
format("mm/dd/yyyy")
dateFormat(intNamedFormat, date())

try these... if you are using asp... I believe you can only use formatDatetime... but I always have to test... and so will you :(... sorry bout that much... but one or any of these should work for you...

good luck my friend!
Dave