Any way to change the format of TONOW() to allow sorting?


#1

Initially, using TONOW() seems like a compact way of calculating time offset from today. But if I create a column that uses TONOW it’s output is in the form of, “5 days”, “15 days”, “1 month”, “2 months”, and etc. That reads well BUT it doesn’t sort well. How can I change the format or cast from the result of TONOW into a raw number that I can sort? I tried DATETIME_FORMAT (TONOW (myDateField)),‘days’) but that only gives and #ERROR.
I’m guessing your guidance will be, “don’t use TONOW” and instead use the DATETIME_DIFF function…

Thanks for any and all help.