Using a web based table for Daylight Savings - suggestions?

[edhans]

I need a table on the web with the daylight savings changes for the US. I have a table on my SQL server, but I have a number of reports that don't use the SQL server, such as those that use Sharepoint or OneDrive, and don't want to tie them to our onprem gateway for such a simple table.

I am currently using this table on the GreenwichMeantime.com site, but may consider the table here on Wikipedia , but was wondering if there was a better table to use that would be rock solid stable.

What sites are you using?

[OwenAuger]

@edhans

I tend to refer to timeanddate.com for this sort of thing, but I can't say I've put this to the test as a data source

It appears that you can query a particular year up to 2030 using a URL like this:

https://www.timeanddate.com/time/change/usa?year=1940

The table at the bottom of the page (detected as Table 0) gives the start and end dates by state.

The table needs to be transformed a little but on the face of it looks quite usable.

Regards,

Owen

[edhans]

I played with that one too. All of the tables I've found are defintely usable. What I would like is a consistent table that is never changed (other than adding records or correcting dates as DST moves around) so any of the .COM sites I'm a bit reluctant to embrace in reports long term.

I'm not even sure I could trust wikipedia. I am wondering if I can publish my own table in Sharepoint somewhere as a publicly avail doc so I don't have to worry about any reports failing to authenticate....