Hey all! Anyone know why this wouldn't be setting...
# suiteflow
b
Hey all! Anyone know why this wouldn't be setting the date properly? It uses a {today} function in the value formula and sets the field value on entry. It says it executes but the field is empty?
d
What's the field type?
b
DateTime I believe
yeah, confirmed
i
just to confirm, the field is set to store value right? can you provide a snippet of the set field value where its setting the date
b
@Israel Gonzalez it is set to store value.
i
try doing the native Date>Today see if that works, else on the formula try new Date({today})
or TO_DATE({today}) forget which one is the correct one since one works for client function and the other for server functions
b
I also wonder if it needs to be set After Record Submit
m
Try selecting "today" in this drop down
j
Have you tried changing the workflow owner's date/time preferences? I seem to vaguely recall having some date issues with workflows where it turned out it was actually feeding off my personal date preferences because I was the workflow owner, even though other users were the ones triggering the workflow. Could totally be wrong here, but worth a shot if you're still stuck.
b
Thanks, James. I'll check that. Its odd because it was working in SB but not Prod...
also on this: there is a lock record action but it should be happening after entry
would the workflow log show a action (set field value) as executed even if the record was locked and it wasn't actually saving that value?
FWIW the custom field didn't have edit access to the role of the workflow owner. Sometimes its the small things 🤷
😲 1
i
Good catch, don't really see permissions set there often
d
That's a rough one.