I’m trying to get ‘Value for new rows’ in a date column to be just the day with no time element. I’m not in Pacific Time so I have to add an adjustment, but I have a few issues with that approach.
I know that you’re working on providing Time Zone support, but in the meantime I’m wondering if there’s a way to make this work.
If I add the formula Now() + hours(21) in ‘value for new rows’, it works as expected, except that it also records the time, which I do not want =3/11/2019 12:13:33 PM I just want the day.
So I tried using the formula Today() + hours(21) which didn’t work =3/10/2019 9:00 PM
I also tried Today + days(0.875) which didn’t work and it still added the time element =3/10/2019 9:00 PM
I don’t think using the formula Today() + days(1) =3/11/2019 is accurate because, even though it doesn’t add the time, it adds 24 hours, not 21.
I find this annoying because when I pull data from the affected column, I don’t want to have a time, just the correct date.
PS I just realised that some daylight saving adjustment must have happened recently in Pacific Time, because I am now 20 hours away…