Has anyone noticed the formula builder will substi...
# suiteflow
n
Has anyone noticed the formula builder will substitute a variable {today} for actually today’s date in my local format? My original formula might be {trandate}-{today} then when opening formula builder it becomes {trandate}-2/4/2021 resulting in an invalid expression. Is that likely my Chrome browser setting or NS?
a
I faced this issue also. A bit annoying but I just edit this formula once more and change a hardcoded date to {today}.
n
That’s what I did (continuously) during morning. Just wondering if it’s a NS issue worth reporting
k
I've never seen it do that before
s
I believe
CURRENT_DATE
works as well, maybe swap to that?
m
{today}
uses local timezone, I believe other methods of getting date use server timezone