Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DATEADD() does not account for daylight savings #36

Open
AHelms opened this issue Mar 14, 2019 · 1 comment
Open

DATEADD() does not account for daylight savings #36

AHelms opened this issue Mar 14, 2019 · 1 comment
Labels

Comments

@AHelms
Copy link

AHelms commented Mar 14, 2019

If you use DATEADD() to add/subtract from a date and there is a time change (daylight savings) between the input date and returned data then there is a chance that the returned date will be off by a day.

This was discovered when using DATEADD($date, -6) where $date was 2019-03-13, the returned date was 2019-03-06 when it should be 2019-03-07. Daylight savings started on 2019-03-10.

@AHelms AHelms added the bug label Mar 14, 2019
@tylerjohnst
Copy link

A total hacky solution might be to add 12 extra hours here: https://github.com/fulcrumapp/fulcrum-expressions/blob/master/functions.coffee#L277

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Development

No branches or pull requests

2 participants