Date format action issue

Hello. I try to create a bot task using RPA recorder.
Steps:

  1. Get time from the website https://www.worldtimeserver.com (for example 3.01.40 PM) into the string variable
  2. I want to convert time in the next format 3.01 PM using Date format. Option - Reformat string
    But I receive an exception.
    > Error executing DateFormatAction

    com.workfusion.studio.rpa.recorder.playback.PlaybackException: Error executing TemplateAction[templateName=DateFormatAction.ftl,id=8,name=Optional[DateFormatAction],parent=1,nextSibling=9,arguments=ActionArguments[outputLocale=[en-US],outputMask=[h:mm a],inputLocale=[en-US],xsi:type=[recorder:DateFormatAction, recorder:DateFormatAction],pollingInterval=[300],active=[true],inputMask=[h:mm:ss a],input=[${city_time_seconds}],targetVariable=[city_time],delay=[0],timeoutMs=[10000],comment=[test1],awaitTimeout=[5000],direction=[STRING_TO_STRING]]]
    at com.workfusion.studio.rpa.recorder.playback.flow.StandardControlFlow.execute(StandardControlFlow.java:54)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:28)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:15)
    at com.workfusion.studio.rpa.recorder.playback.player.ActionPlayer.next(ActionPlayer.java:81)
    at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.playNextAction(PlaybackLogic.java:154)
    at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.run(PlaybackLogic.java:112)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.time.format.DateTimeParseException: Text ‘2:11:27 PM’ could not be parsed: Conflict found: HourOfDay 0 differs from HourOfDay 14 while resolving AmPmOfDay
    at java.time.format.DateTimeFormatter.createError(DateTimeFormatter.java:1920)
    at java.time.format.DateTimeFormatter.parseBest(DateTimeFormatter.java:1909)
    at com.workfusion.studio.rpa.recorder.api.internal.representation.RDateTimeRepresentation$CustomRepresentation.parse(RDateTimeRepresentation.java:140)
    at com.workfusion.studio.rpa.recorder.api.internal.representation.RDateTimeRepresentation.getValue(RDateTimeRepresentation.java:53)
    at com.workfusion.studio.rpa.recorder.api.types.RDateTime.fromRepresentation(RDateTime.java:104)
    at com.workfusion.studio.rpa.recorder.api.types.RDateTime$fromRepresentation.call(Unknown Source)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:136)
    at Script9.run(Script9.groovy:9)
    at com.workfusion.studio.rpa.recorder.playback.shell.GroovyShellWrapper.executeScript(GroovyShellWrapper.java:48)
    at com.workfusion.studio.rpa.recorder.playback.player.PlaybackContext.executeScript(PlaybackContext.java:108)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.executeBehavior(TemplateAction.java:33)
    at com.workfusion.studio.rpa.recorder.playback.flow.StandardControlFlow.execute(StandardControlFlow.java:46)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:28)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:15)
    at com.workfusion.studio.rpa.recorder.playback.player.ActionPlayer.next(ActionPlayer.java:81)
    at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.playNextAction(PlaybackLogic.java:154)
    at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.run(PlaybackLogic.java:112)
    at java.lang.Thread.run(Thread.java:745)
    Caused by: java.time.DateTimeException: Conflict found: HourOfDay 0 differs from HourOfDay 14 while resolving AmPmOfDay
    at java.time.format.Parsed.updateCheckConflict(Parsed.java:320)
    at java.time.format.Parsed.resolveTimeFields(Parsed.java:394)
    at java.time.format.Parsed.resolveFields(Parsed.java:258)
    at java.time.format.Parsed.resolve(Parsed.java:244)
    at java.time.format.DateTimeParseContext.toResolved(DateTimeParseContext.java:331)
    at java.time.format.DateTimeFormatter.parseResolved0(DateTimeFormatter.java:1955)
    at java.time.format.DateTimeFormatter.parseBest(DateTimeFormatter.java:1897)
    at com.workfusion.studio.rpa.recorder.api.internal.representation.RDateTimeRepresentation$CustomRepresentation.parse(RDateTimeRepresentation.java:140)
    at com.workfusion.studio.rpa.recorder.api.internal.representation.RDateTimeRepresentation.getValue(RDateTimeRepresentation.java:53)
    at com.workfusion.studio.rpa.recorder.api.types.RDateTime.fromRepresentation(RDateTime.java:104)
    at com.workfusion.studio.rpa.recorder.api.types.RDateTime$fromRepresentation.call(Unknown Source)
    at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
    at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:136)
    at Script9.run(Script9.groovy:9)
    at com.workfusion.studio.rpa.recorder.playback.shell.GroovyShellWrapper.executeScript(GroovyShellWrapper.java:48)
    at com.workfusion.studio.rpa.recorder.playback.player.PlaybackContext.executeScript(PlaybackContext.java:108)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.executeBehavior(TemplateAction.java:33)
    at com.workfusion.studio.rpa.recorder.playback.flow.StandardControlFlow.execute(StandardControlFlow.java:46)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:28)
    at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.execute(TemplateAction.java:15)
    at com.workfusion.studio.rpa.recorder.playback.player.ActionPlayer.next(ActionPlayer.java:81)
    at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.playNextAction(PlaybackLogic.java:154)
    at com.workfusion.studio.rpa.recorder.player.PlaybackLogic.run(PlaybackLogic.java:112)
    at java.lang.Thread.run(Thread.java:745)


    execution-result.log.csv (261 Bytes)
    I add execution-result.log all previous steps.
    Please prompt me on what is going wrong.

i am trying to convert string into date format but i am am getting error as below:
string variable value is 8/22/2018 3:25 AM

Caused by: java.time.format.DateTimeParseException: Text ‘8/22/2018 3:25 AM’ could not be parsed: Conflict found: HourOfDay 0 differs from HourOfDay 3 while resolving AmPmOfDay
at java.time.format.DateTimeFormatter.createError(DateTimeFormatter.java:1920)
at java.time.format.DateTimeFormatter.parseBest(DateTimeFormatter.java:1909)
at com.workfusion.studio.rpa.recorder.api.internal.representation.RDateTimeRepresentation$CustomRepresentation.parse(RDateTimeRepresentation.java:140)
at com.workfusion.studio.rpa.recorder.api.internal.representation.RDateTimeRepresentation.getValue(RDateTimeRepresentation.java:53)
at com.workfusion.studio.rpa.recorder.api.types.RDateTime.fromRepresentation(RDateTime.java:104)
at com.workfusion.studio.rpa.recorder.api.types.RDateTime$fromRepresentation.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:47)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:136)
at Script2.run(Script2.groovy:8)
at com.workfusion.studio.rpa.recorder.playback.shell.GroovyShellWrapper.executeScript(GroovyShellWrapper.java:48)
at com.workfusion.studio.rpa.recorder.playback.player.PlaybackContext.executeScript(PlaybackContext.java:108)
at com.workfusion.studio.rpa.recorder.playback.action.template.TemplateAction.executeBehavior(TemplateAction.java:33)
at com.workfusion.studio.rpa.recorder.playback.flow.StandardControlFlow.execute(StandardControlFlow.java:46)
… 6 common frames omitted

i am also attaching the recording screenshot:

@ashapkina, Need help on this issue.

@ihorvat @shivangee_sunX we’ll look into this issue. It looks like it might be a bug.

1 Like

Hello @ashapkina ,
I have the same problem.
Do you have a solution ?

Hi @afoulon sorry, it hasn’t been fixed yet.