Hi
I made a query listing the last modification date of models . This query is used as a data feed for dashboards.
I would like to add a column counting the number of days between now (today) and the last modification date for each model : how would you do it ? ( adding a raql operator is OK but I do not know how to do it at the moment)
Our Aris version is 10.0.26
Hi,
Most likely you can do it without RAQL.
You can use the formula: =Today()
and let ARIS do the math with the formula: =days(DATE1;DATE2) as visualized below.
Maybe this helps or gives you some idea :)
Best,
Veronika
And if you really want to do that in RAQL (if you are using other datasources than queries )
You can use standard ANSI SQL also in RAQL - and compute everything in seconds, subtract and convert back to days
This is only a showcase - because RAQL was asked - I would do it exactly as Veronika has suggested
Veronika Ellermann on
Hi,
Most likely you can do it without RAQL.
You can use the formula: =Today()
and let ARIS do the math with the formula: =days(DATE1;DATE2) as visualized below.
Maybe this helps or gives you some idea :)
Best,
Veronika