Android Question Problem with DateUtils

[RB Smissaert]

Using the latest DateUtils library, 1.05.

Running this code:

Dim lDate As Long
lDate = DateUtils.SetDate(1970,1,1)
Log(lDate)

I expect this to produce 0, but instead I get 3600000

Any idea what I might be doing wrong?

RBS

 

[RB Smissaert]

Using the latest DateUtils library, 1.05.

Running this code:

Dim lDate As Long
lDate = DateUtils.SetDate(1970,1,1)
Log(lDate)

I expect this to produce 0, but instead I get 3600000

Any idea what I might be doing wrong?

RBS

Sorry, that should be -3600000

RBS

 

[Erel]

Any idea what I might be doing wrong?

Yes, a similar issue is explained in this tutorial:


Tip: if you need to make "corrections" to the time zone effects then you are doing something wrong.

 

[RB Smissaert]

Yes, a similar issue is explained in this tutorial:


Tip: if you need to make "corrections" to the time zone effects then you are doing something wrong.

OK, thanks. I wrongly presumed that DST wouldn't affect DateUtils.SetDate(1970,1,1).

I solved this now with a Public variable (set once in Sub Service_Create):

General.lTicksOff = DateUtils.SetDate(1970, 1, 1)

Now this function works fine:

Public Sub Ticks2ExcelDate(lTicks As Long) As Long
 Return 25569 + ((lTicks - lTicksOff) / 86400000)
End Sub

RBS