Skip to content

dateDiff() works in morning, not in afternoon. #46

@demmings

Description

@demmings

In order for my tests to always work, I added this as a test for dateDiff() so that it would always return '7'.
There is something wrong with the ROUNDING. I call FLOOR, but it appears to be rounding up. Anyway, not sure at this point.

The only weird thing is that the tests always seems to work when run in Google Sheets. It just appears to only fail in NODE.JS. Anyway, it causes my tests to sometimes fail.

datediff(adddate(curDate(),7), now())

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions