Setting Date and Time in a DDE Action
I have a date that is set in an Action that is set using the SET Date Action Type with the Date Option of "Current Date". Even thought the date field being populated is configured for Date and Time, this field is set to the current date but a time of 12:00am. I am using this field in a calculation to compare to the create date that has the Date and Time. This is not a problem if at least 19 hours (24 - 5 for GMT Difference) has past since the Create Date/Time, otherwise it does not give me the result I expect.
Any suggestions on how I can populate the date field in the action with date and time.
It should be noted we are on 6.1.1.
In your calculation, can you add your UTC offset to the date field first before doing your calc? See below for an example where I've added 5 hours back to the [Date Field] being set by DDE.
DATEDIF([Create Date], DATEADD(HOUR, 5, [Date Field]), DAY) > 1,
So Something Else
DDEs don't allow you to populate the time into a field.
Is the field you are setting something you can change to a calculation? What is driving the "Rule" of the DDE? Is it a status change or somethign you can build into a calculation?
I'm trying to default the current date & time using a calculated date field when a Status changes to Approves. I've tried a few different versions trying to use CONTAINS and NOW()
Everything returns an "Error".
Any ideas what the correct syntax should be to accomplish?
CONTAINS(EXACT, [Primary Review Status], (VALUEOF([Primary Review Status],"Approved"),"NOW()"))
The formula validates, but returns an Error.
I would also wrap that in an IF statement unless you want the date/time to be updated on future recalcs. I would suggest something like:
[Primary Review Status]=VALUEOF([Primary Review Status],"Approved")