time format 1

[teroy]

I have a date which is as follows 2000-12-02 19:23:08.000
i want to change it to 2000-12-02 20:23:08.000 for daylight savings...

anyone know how i can do this..

much appreciated

 

[swilliams]

I think (it's been a long time) that there are functions to add intervals to times. Without the help files infromt of me, try looking up DateAdd.

Simon

 

[teroy]

a bit more on it. When daylight savings finishes. It needs to know it..and not add a hour.

Hope this makes sense

 

[teroy]

yup..just used date add as a temporary fix..

What i'm doin is a time online program..only problem is when daylight savings finishes it will still be adding the extra hour

 

[swilliams]

You can check the current date (of the system at least) and if you are in the period where daylight saving is on, then do the calculation.

Simon