topic Re: Assign the difference between 2 variables to a new variable in App Development

Assign the difference between 2 variables to a new variable

Milaf — Fri, 03 May 2024 12:30:43 GMT

Hi,

I need to somehow get the difference between two dates assigned to variables and assign it in a new variable, what am I missing?

QFlag:
LOAD
EmptyColumn,
DateColumn
FROM [lib://QVDFilePath/QFlag.qvd]
(qvd);

LET vData=Peek('DateColumn', 0, Timestamp(QFlag,'YYYY/MM/DD hh:mm/ss'));
LET DateNow = Timestamp(Now(),'YYYY/MM/DD hh:mm/ss');
Let vMinus = Interval(($vData- $DateNow ), 'mm');

Drop Tables QFlag;

Trace '$(vData)';
Trace '$(DateNow)';

Results:

Thank you.

Re: Assign the difference between 2 variables to a new variable

MatheusC — Fri, 03 May 2024 18:47:30 GMT

@Milaf
try like this:

Let vMinus = interval(Timestamp#('$(vData)','YYYY/MM/DD hh:mm/ss') - Timestamp#('$(DateNow)','YYYY/MM/DD hh:mm/ss'),'hh:mm');

Regarts, Matheus

Re: Assign the difference between 2 variables to a new variable

Milaf — Mon, 06 May 2024 06:20:57 GMT

Thank You MatheusC,

It Works! 🙂 But result is ;