Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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
@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
Thank You MatheusC,
It Works! 🙂 But result is ;