+2Hello Everyone
I have not tried using the Expression builder yet, but I have an urgent request from the company to build an escalation on our Offboarding tickets. I just need to do a check to see if the offboarding Date = Today and if true send an escalation email to the assigned manager and agent. I have the ISO date placeholder, but I have no idea how to build the expression. AI was not able to assist me, so I am now asking the champs lol :).
Best answer by BrynCYDEF
Hi
There is no list anywhere to find the names of the time zones according to Fresh Works.
I created a similar expression but using DiffinDays() ** but I cannot test anymore due to a bug so I’m optimistic this will work but not sure.
**P.S. I reported this apparent bug where I can no longer test Expression properly anymore bc the Test Expression function doesn’t “see” the name of the field being tested but always defaults to {{ticket.id}}
Anyway, aside from this one shown in the Help Guide (Asia/Kolkata) - only “GMT” or “UTC” work and nothing else. I tried now(‘UTC’) and now(‘GMT’) and those both worked and you can use either Date or Datetime as output options or as above with the Boolean output.
However, none of these were accepted:
“Eastern”, “Eastern Time”, “New York”, “Harare”, “Eastern Time (US & Canada)” as shown on the Contact page, “IST”, “India Standard Time” so on and so on with no luck.
+11Not sure if there is a “todays” date. there is a today’s date and time.. but mot helpful…
+2I have not used expression builder either, but I do that exact thing using a PowerShell node
+16Hello
+2Hello
Thanks will try and let you know :)
Hi
There is no list anywhere to find the names of the time zones according to Fresh Works.
I created a similar expression but using DiffinDays() ** but I cannot test anymore due to a bug so I’m optimistic this will work but not sure.
**P.S. I reported this apparent bug where I can no longer test Expression properly anymore bc the Test Expression function doesn’t “see” the name of the field being tested but always defaults to {{ticket.id}}
Anyway, aside from this one shown in the Help Guide (Asia/Kolkata) - only “GMT” or “UTC” work and nothing else. I tried now(‘UTC’) and now(‘GMT’) and those both worked and you can use either Date or Datetime as output options or as above with the Boolean output.
However, none of these were accepted:
“Eastern”, “Eastern Time”, “New York”, “Harare”, “Eastern Time (US & Canada)” as shown on the Contact page, “IST”, “India Standard Time” so on and so on with no luck.
+10Hii
Sure! I’ll loop in someone from the FS team to get you the list!
+4Hi
TY
TY
Much appreciated, team!! :-)
+16Hello
Hope that helps!
+2Hi
There is no list anywhere to find the names of the time zones according to Fresh Works.
I created a similar expression but using DiffinDays() ** but I cannot test anymore due to a bug so I’m optimistic this will work but not sure.
**P.S. I reported this apparent bug where I can no longer test Expression properly anymore bc the Test Expression function doesn’t “see” the name of the field being tested but always defaults to {{ticket.id}}
This is the first one that i could get to work perfectly, thank you very much for your help :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
