topic Formula for Date/Time Field in DemandTools

Formula for Date/Time Field

bbrouard — Wed, 17 Sep 2025 15:18:52 GMT

I'm looking to build a formula for a date/time field where the date varies but the time is consistent. When I try to do this, I encounter errors.

Goal:
Have the date be for "today" (whatever date that is) but the time be 14:00 EST.

Attempted Formula:
DATETIMEVALUE(TEXT(TODAY()) + ' 18:00:00')

Error Message:
There seems to be a problem with the formula syntax, please check it over and try again.

How can I build a formula that will reach my goal?

Re: Formula for Date/Time Field

Pugs_Validity — Fri, 19 Sep 2025 17:55:46 GMT

Hey @bbrouard - This one stumped me but thanks to a collective effort, mainly @JonG_Validity, we have a solution! I learned something myself in this effort so appreciate the question! DATETIMEVALUE does not translate into a DemandTools Modify formula as it would in Salesforce, so you need to make a slight adjustment depending on your time zone settings: TEXT(TODAY(),"yyyy-mm-dd") & "T18:00:00Z"

Re: Formula for Date/Time Field

bbrouard — Fri, 19 Sep 2025 18:39:07 GMT

@Pugs_Validity and @JonG_Validity , thank you both so much!! I just tested the formula and it worked beautifully. I'm so excited to use this in the live data!