To give some quick background - I'm migrating from using the Connector, to using the S3 in the Rules Engine. And in one of the reports that automated to me from our Service Desk has a DateTime field. After a few trial and errors a lot of Partially Failed reports - I found that because some of my time entries don't have a leading zero, M/D/YYYY HH:MM isn't working. I'm in need of a M/D/YYYY H:MM option.
Anyone else running into this?
Idea. In the Rules Engine, S3 Dataset - Add M/D/YYYY H:MM as an DateTime Format Option.
+5
+5Yes, I see this quite often in my customer's implementations. I often have to manually change the date/time format and then communicate to the customer that they need to change to hh:mm moving forward. I agree that just having a h:mm format would be much more convenient.
Does a date-time formats like below help you cover Hour & Minute (both) with or without leading zeros?
M/d/YYYY H:M - there are no seconds
M/d/YYYY H:M:s - with seconds, works for both 05:02:05 or 5:2:5
M/d/YYYY H:M - there are no seconds
M/d/YYYY H:M:s - with seconds, works for both 05:02:05 or 5:2:5
+5Hi Ankit!
I would still need MM, as the minutes do have the leading zero - it's just the hour that does not. So I would be looking for: M/D/YYYY H:MM or M/D/YYYY H:MM:SS.
I would still need MM, as the minutes do have the leading zero - it's just the hour that does not. So I would be looking for: M/D/YYYY H:MM or M/D/YYYY H:MM:SS.
+5Hi Spencer! I'm in the same boat - I can either manually edit the report, and hope Service Desk can add the leading zero before I get the report. Or, I continue to use Connectors for the time being. Using the Rules Engine to handle the S3 it just so much easier! And cleaner! :)
+1Hi Sagan, Its a valid ask, redirecting this to our product team.
Thanks for posting!
Thanks for posting!
+5Thank you Sai! :)
Has a solution been implemented for this when leading zeros are not present? Or, are others reverting back to Connectors for a solution?
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.