Getting the now() date in the workflow

[KirtiSikarwar]

Please be sure you’ve read the docs and API specs before asking for help. Also, please be sure you’ve searched the forum for your answer before you create a new topic.

I need the now() date to be retrieved to compare it with the start date. This works perfectly. But the now() date is coming in the UTC format and my date is coming in the AEST format.

{
  "name": "now",
  "description": "Get the current date and format it as ISO8601",
  "transforms": [
    {
      "id": "sp:transform:substring:string",
      "input": {
        "start": 0,
        "length": 10
      }
    }
  ],
  "variableA.$": "$.now()"
}

[sjoyee (Jo Yee Siang)]

Hi @KirtiSikarwar, I believe in the Define Variable operator, you can choose the Add Time Date Transform and add 11 hours to $.now() if it is UTC+11 for example.

Hope this helps in your use case.

[KirtiSikarwar]

@sjoyee

UTC+11

would Add work? as subtract isnt supported yet

[KirtiSikarwar]

Added the time from operators option to 10 hrs - UTC to AEST

[sjoyee (Jo Yee Siang)]

I see. How about adding 10 hours first, then only substring to length 10?