This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello,
DateAdd appears to be adding days incorrectly.
To replicate:
Col1: date field (date only, no time)
Col2: DATEADD(Col1,1,‘d’)
Format Col2 to show date only, no time.
In this case, Col2 shows the same date as Col1. When time is shown, behavior s...
The time zone was the crux of the issue. Looks like you have to tick the box that says “use the same time zone (GMT) for all collaborators” in the formatting tab. I had it unchecked.
I am not sure I understand that feature, but I will remember to kee...
