sql server reporting services: Date stored as int -- sql server reporting services

Date stored as int

Clueless
7/26/2006 8:32:35 AM

sql server reporting services:

I get a conversion error when using the 'seconds since epoch' integer
with CDate.

So I found this routine in this news group that is supposed to fix it:

=DateTime.FromOADate(CDbl( Fields!Arrival_Time.Value /
86400)).AddYears(70).AddDays(1).AddHours(-6)

But "FromOADate" is an "unrecognized identifier" -- I am using
Microsoft SQL Server Reporting Services Designers Version 9.00.1399.00

Need help!

Re: Date stored as int (need Daylight Savings Time routine added)

Clueless
7/26/2006 9:12:51 AM

Ok... This actually works even though "FromOADate" is flagged as
unrecognized, it produces the proper date. However, the GMT offset '-6'
is hardcoded in this example, how do I account for daylight savings
time in the display? Is there a routine for this?

Thanks for your help.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.