load a QWP with data offset to today's date?

LabKey Support Forum (Inactive)
load a QWP with data offset to today's date? jeckels  2010-10-18 17:34
Status: Closed
 
Hi Ben,

The only idea that comes immediately to mind is to do it in a custom query, where you add a calculated column that looks something like:

ABS(TIMESTAMPDIFF('SQL_TSI_DAY', <DateColumn>, NOW()))

and sort descending on that value.

Thanks,
Josh