DQL - the last backup value from sqlserver

[henk_stobbe]

Hello,

I want to use the last backup value from sqlserver to create a dashboard showing the last backup time and date.

Problem the value returned is in minutes passed....

Who known or has already a way to converted this in a timestamp?

KR Henk 

[krzysztof_hoja · Accepted solution]

I hope this example helps:

data record(min = 120)
| fieldsAdd now(), when = now() - duration(min, "m")

[henk_stobbe]

Hi Krzysztof,

Works perfect, 

Thanks for your swift response!