Now() function returns an hour behind system time since daylight savings change

[Anonymous]

Hi, when i call the Now() function since the clocks went forward yesterday, the datetime returned is 1 hour behind system.  Windows is in the right time zone (UK/Ireland) with daylight savings adjustment enabled and is showing the correct time. Is there anything i can do to avoid this issue?  Seems like a bug? Thanks, Jeremy    

[Denis__Dennehy]

I'm not sure what the Now() function returns - but there is a LocalTime function you can use if you want to be sure of using the local desktop time rather than UTC.

[Anonymous]

Well to answer my own question, I can use 'ToDateTime(Today()&"" ""&LocalTime())' in order get the datetime as of ""now"", including the daylight savings time.  But before I go change a lot of stuff, can someone confirm if this is the expected behaviour?   I dont remember having this issue last year... Thanks

[Anonymous]

@Denis   Didn't see your post before replying, but yeah I figured out that LocalTime does include daylight savings, so maybe Now () is supposed to be UTC...