Use the concat function
Use the rule's concat function to add a time zone abbreviation to the cell value. See below example:
Rule block code below:
set $(TIMEZONE) " GMT"
value parseDate ("%Y-%m-%d %H:%M:%S %Z", concat(path "PathCell" value, $(TIMEZONE)))
parseDate function
The parseDate function uses the time zone of the Gateway host. However, there are cases wherein the value displayed on a cell uses a different time zone and the time zone abbreviation is not explicitly displayed. The above solution adds the time zone abbreviation to a cell value prior to comparison or conversion to epoch format.
Comments
0 comments
Please sign in to leave a comment.