topic Hi Team, In both env i am… in Product Forum

FormatDateTime Error

DharmendraGupta — Thu, 21 Jun 2018 12:24:00 GMT

Hi Team, I have used FormatDateTime. It is working in development/UAT system but not on production system. I had imported the BP release of the same process in production system. Error : CALCULATION: 'Fetch last run start datetime' Process: 'Process Name' Subsheet: 'Fetch run timings' ERROR: Internal : Failed to evaluate expression 'FormatDateTime([Last run start datetime]; "MM/dd/yyyy HH:mm:ss")' - FormatDateTime function requires 2 arguments of types: (datetime,text)

Do the logs show what the…

NicholasBell1 — Fri, 22 Jun 2018 12:55:00 GMT

Do the logs show what the value of [Last run start datetime] was?

Hi Dharmendra It seems…

RanjeetPatel1 — Sat, 23 Jun 2018 20:39:00 GMT

Hi Dharmendra It seems your variable value at run time is null , hence the expression evaluation fails. Check the run time value in logs. Regards Ranjeet

Hi Team, In both env i am…

DharmendraGupta — Wed, 03 Oct 2018 12:42:00 GMT

Hi Team, In both env i am getting same value for [Last run start datetime] ie ""9/27/2018 11:45:00"" and with Text datatype. In UAT below expression working as expected and returns ""09/27/2018 11:45:00"" But in Prod if [Last run start datetime] is ""27/9/2018 11:45:00"" then only expression returns ""09/27/2018 11:45:00"" else throws same error. FormatDateTime([Last run start datetime], ""MM/dd/yyyy HH:mm:ss"") It got resolved last time after changes in region and dattime setting.

This might help https:/…

John__Carter — Wed, 03 Oct 2018 12:55:00 GMT

This might help https://portal.blueprism.com/documents/v6-data-sheet-date-and-time-hand…

RE: FormatDateTime Error

EVIPUTI — Thu, 09 Sep 2021 06:48:00 GMT

@Dharmendra Gupta The problem is that the first argument should be in the format date (or a text which can be converted to date).
It depends on the format of your computer system. Seems your prod is following some other format of date and thats why when BP is trying to convert its failing . Simply swap the day with the month and then you can use the FormatDate function.

------------------------------
------------------------------
Vipul Tiwari
Senior Process Simplification and Optimization Designer(Solutions Architect)
Fidelity International
------------------------------
------------------------------