 |
You can use the concat function to add a timezone STD ABBR to a cell value. See below:
|
 |
The parseDate function uses the timezone of the Gateway host. However, there are cases wherein the value displayed on a cell uses a different timezone but the actual timezone is not explicitly displayed. The above solution adds the said timezone to a cell value prior the comparison or conversion to epoch format. |
Comments
0 comments
Please sign in to leave a comment.