Dmitry K¶
TABLE WITHOUT ID
file.link AS "Contact note",
file.day + ": **" + T + " days**" AS "Last contact"
FROM [](#)
FLATTEN (date(today) - file.day).days AS T
SORT file.day desc
LIMIT 1
TABLE WITHOUT ID
file.link AS "Contact note",
file.day + ": **" + T + " days**" AS "Last contact"
FROM [](#)
FLATTEN (date(today) - file.day).days AS T
SORT file.day desc
LIMIT 1