Skip to main content
New Idea

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

Related products:CS Rules Engine

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
Forum|alt.badge.img+6
  • Helper ⭐️⭐️
  • 236 replies
  • 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
Forum|alt.badge.img+11
  • VIP ⭐️⭐️⭐️⭐️⭐️
  • 646 replies
  • 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. 


  • Contributor ⭐️⭐️⭐️
  • 16 replies
  • October 5, 2024

Adding Screenshots:

Step 1:
 



Step 2:


Step 3:

 

 


pchoe
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️
  • 10 replies
  • November 18, 2024
ganesh.patil wrote:

Adding Screenshots:

Step 1:
 



Step 2:


Step 3:

 

 

MVP


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings