Formula for Date/Time Field

[bbrouard]

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? 

[Pugs_Validity]

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"

[bbrouard]

@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!