hello! i am working on a workflow, and i'd like to...
# suiteflown
Neeranie Ramdas
10/30/2024, 10:26 PMhello! i am working on a workflow, and i'd like to set a value if a custom datetime field value is greater than 1 day ago. i am thinking this should be a before/after record submit action. i've tried {today}-{customdatefield}>=1, but i am not having any luck. please help
Neeranie Ramdas
10/30/2024, 10:36 PMalso tried this formula: TRUNC({custbody_last_dnal}) <= TRUNC({{custbody_today})-1)
t
Tim Chapman
10/30/2024, 10:37 PMHow does this customdatefield display?
n
Neeranie Ramdas
10/30/2024, 10:38 PMdate and time. ex: 10/29/2024 11:24 am
t
Tim Chapman
10/30/2024, 10:38 PMIf it's a date & time field (showing both) I wouldn't be suprised if it's not calculating that
Tim Chapman
10/30/2024, 10:38 PMBecause the {today} field is just a date?
n
Neeranie Ramdas
10/30/2024, 10:39 PMi have another custom field that has today's date and time - but no luck there, either
t
Tim Chapman
10/30/2024, 10:39 PMI know for a fact that you subtract just date fields, I have multiple Saved Searches that do that.
Tim Chapman
10/30/2024, 10:39 PMBut I highly doubt you can subtract a date/time from a date
Tim Chapman
10/30/2024, 10:39 PMI'm not even sure if you can subtract a date/time from a date/time
n
Neeranie Ramdas
10/30/2024, 10:40 PMi am thinking that is the issue...
t
Tim Chapman
10/30/2024, 10:40 PMSo if you redo your custom date/time field and change it to a date you should be able to subtract it from {today}
n
Neeranie Ramdas
10/30/2024, 10:41 PMthere's no way i can convert a datetime field to a date in a formula?
t
Tim Chapman
10/30/2024, 10:41 PMIs this a saved search condition?
Tim Chapman
10/30/2024, 10:42 PMOr just a formula condition in the workflow
n
Neeranie Ramdas
10/30/2024, 10:42 PMworkflow condition
t
Tim Chapman
10/30/2024, 10:45 PMI don't see a formula(numeric) in the field of the workflow conditions
Tim Chapman
10/30/2024, 10:45 PMDo you?
n
Neeranie Ramdas
10/30/2024, 10:46 PMno
t
Tim Chapman
10/30/2024, 10:46 PMDo you need the time component?
n
Neeranie Ramdas
10/30/2024, 10:46 PMnot necessarily
t
Tim Chapman
10/30/2024, 10:48 PMSimple solution is just to convert the date/time into a date but there is probably other solutions.
Tim Chapman
10/30/2024, 10:48 PMAt least we figured out the problem
Tim Chapman
10/30/2024, 10:49 PMI think you'll have a lot more flexibility with a saved search condition if thats possible for you
Tim Chapman
10/30/2024, 10:49 PMAnd I'd be willing to bet you convert one via formula so it would calculate date field - date field leaving out the time component.
n
Neeranie Ramdas
10/30/2024, 10:50 PMi was trying not to use a saved search because the custom date field i'm looking at is a not store value field
t
Tim Chapman
10/30/2024, 10:51 PMYou could make another WF and date/time field that can set the new date/time field on record save as a stored value
Tim Chapman
10/30/2024, 10:51 PMSourcing from the original date/time field
Tim Chapman
10/30/2024, 10:51 PMthat is non-stored
Tim Chapman
10/30/2024, 10:52 PMYou can do workflow conditions that subtract a non-stored value from {today}?
n
Neeranie Ramdas
10/30/2024, 10:53 PMin workflows, you can use non-stored values in a condition. but if i can't get the date comparison to work, i will do what you last suggested
t
Tim Chapman
10/30/2024, 10:55 PMWell good luck!
n
Neeranie Ramdas
10/30/2024, 10:55 PMthanks so much!!
i
Israel Gonzalez
10/30/2024, 11:04 PMI have found date conditions in Workflows to be unreliable, i have a formula that works 95% of the time, the other 5% it returns invalid expression error. Even though they are for the same customer, same context, even on the same API request. I had a longstanding case with NS Support and ACS and they could not admit to the issue but where able to replicate on their side. They offered no solution.
not sure if this helps any but you can wrap it around a TO_DATE and see if that works. It's too late for me to think what your logic would be but this is what I have used when checking between a date range.
TO_DATE({today}, 'MM/DD/YYYY') BETWEEN TO_DATE('06/03/2024', 'MM/DD/YYYY') AND TO_DATE('06/14/2024', 'MM/DD/YYYY')
n
Neeranie Ramdas
10/31/2024, 3:00 PMi tried to_date with no luck. thank you for your input, really appreciate it!