Sam P Posted May 21, 2024 Posted May 21, 2024 I think there may be an issue with the new Hornbill Date Formatter node in that it does not seem to act in the same way as the Cloud Automation node that does the same thing. (Also if you have any tips on how better to manage BST please let me know). Regional settings are set to GMT. My Change start date is written to CF21 in the IC. I then want to use that date and time to add to a Card and to an External Authorisation. For 6 months of the year I need to +1 hour for BST ( @Berto2002 post here was helpful https://community.hornbill.com/topic/26540-how-do-you-get-around-the-impact-of-uk-daylight-savings-bst-in-datetime-fields-for-non-ui-datetime-processing/#comment-122966). Here is my output, unless I have it hugely wrong I think the time is not being picked up in the new node:
Sam P Posted May 22, 2024 Author Posted May 22, 2024 @Steve G I might have posted this in the wrong place, would it be possible for you/ someone to review when you have time? Thanks
Berto2002 Posted May 23, 2024 Posted May 23, 2024 Maybe you meant @Steve Giller? Following this in case it affects my existing solution @Sam P I don't know much about these date formats but I can see your Input format has the Z in it which tells the system it's UTC ("zulu time"). However, in the case of your CF21 entry, the time is NOT UTC (no Z on the end) so this could explain why you get an "unexpected" result. What happens if you drop the Z on the Input and run that against your CF21 value? Does that preserve the 07:00?
Victor Posted May 23, 2024 Posted May 23, 2024 @Berto2002 actually @Steve G is the right mention ... @Sam P I have moved this to the integrations section... 1
Sam P Posted June 5, 2024 Author Posted June 5, 2024 @Berto2002thanks I tried dropping the Z with the same results (I don't want to preserve the 07.00, I want the output to be 07.00+01.00 for BST) but I still believe the new Date Formatter node is behaving differently to the old one that is due to be retired from Cloud Automations in the future @Steve G hopefully you might be able to help here, I will use the Cloud Automation node for now.
Jordan Gooding-McGovern Posted June 6, 2024 Posted June 6, 2024 @Sam P Hey Sam, thanks for bringing this up. I've updated the automation and it should be fixed with the next core release. 1 1
Berto2002 Posted June 6, 2024 Posted June 6, 2024 @Jordan Gooding-McGovern with or without the Z on the input for the GMT field?
Jordan Gooding-McGovern Posted June 6, 2024 Posted June 6, 2024 @Berto2002 With the Z on the end. The aim was to ensure the original functionality remains and any introduced bugs (introduced from the port of iBridge to Hornbill Automation) like the one Sam's experiencing, gets ironed out.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now