Skip to main content
Gainsight Employee ⭐️
May 9, 2024
New Idea

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

Related products:CS Rules Engine
  • May 9, 2024
  • 4 replies
  • 271 views

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.

4 replies

kstim
Helper ⭐️⭐️
May 9, 2024

@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 HH:mm:ss)
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.

alizee
VIP ⭐️⭐️⭐️⭐️⭐️
July 25, 2024

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. 

The most expensive part of building is the mistakes. That's true in construction. Not so much in CSOps. So ask questions, make mistakes and learn. All views expressed here are my own.
Contributor ⭐️⭐️⭐️
October 5, 2024

Adding Screenshots:

Step 1:
 



Step 2:


Step 3:

 

 

pchoe
Contributor ⭐️⭐️⭐️
November 18, 2024

Adding Screenshots:

Step 1:
 



Step 2:


Step 3:

 

 

MVP