'Unable to sort datetime using variable computed from datetime string
I am trying to sort a table by datetime in descending order. I currently am trying to use a variable to be the field to be used in sorting.
Example data:
| header A | datetime |
|---|---|
| First | 01 Jan 2021 |
| Second | 17 Aug 2021 |
I created a variable, as seen below,to try to sort the records.
After creating the Long variable from the DATEVALUE expression, after converting to string, it shows null when I load it into preview. Also, it does not sort properly after using it as a sort field.
Some help is much appreciated.
Solution 1:[1]
The dataset included the epoch of the date. I used that to sort.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | diggledoot |