Rules Engine: ability to convert date to date-time field

Currently, we don’t have ability to convert data type field to date-time. We have To DateTime date type function available but it’s only allowing to select string-type fields. It will be better idea if we can enhance the feature and provide ability to convert date to date-time with default HH:MM:SS.

Page 1 / 1

@caitlin_ankney and Jen P. have figured out a way to do this so all of the credit goes to them, not me!

Directly from Jen herself in the GGA slack group:

Step 1: Use a transform & formula field to convert Date field to String field
Step 2: Use a second transform & formula field to convert the new String field to a second new String field using Concat & add a space + your default time in the format you want to use in your datetime field (I did HHss)
Step 3: Use a third transform & formula field to convert the second new String field using a To DateTime formula.

Despite this wonderful workaround, it would be nice to have a cleaner and easier way of converting a date field to a date-time field.

While the workaround is easy enough, it’s silly to have to go through this kind of brittle transformation to achieve this. We can do the reverse scenario, so let’s make that one happen.

Adding Screenshots:

Step 1: