topic Last 4 hours in App Development

Last 4 hours

TeodoraBurlica — Fri, 17 Jun 2022 10:53:20 GMT

Hi,

I want to calculate last 4 hours in script, but it's not working. I have the following expressions:

MinMaxDate:

LOAD

Max(TimeStamp(STAMP)) as MaxDate

Resident Table;

LET vMaxDate = peek ('MaxDate', 0, 'MinMaxDate');

FilterCalendar:

LOAD distinct

STAMP

Resident Table

Where $(vMaxDate) - timestamp(STAMP) <4/24;

Any ideas?

Re: Last 4 hours

hic — Fri, 17 Jun 2022 14:34:11 GMT

It all depends on how the data looks...

But the most probable cause, is that vMaxDate is formatted as a timestamp, and then your dollar expansion will cause problems:
... Where $(vMaxDate) - timestamp(STAMP) <4/24;
probably expands to something like
... Where 2022-06-20 13:14:15 - timestamp(STAMP) <4/24;
which will give an error.

Try single quotes:
... Where '$(vMaxDate)' - STAMP <4/24;

Re: Last 4 hours

TeodoraBurlica — Fri, 17 Jun 2022 14:51:04 GMT

It works! Thank you