topic Re: Comparing Data Field with Today() Variable in App Development

Comparing Data Field with Today() Variable

Anonymous — Wed, 22 Aug 2018 19:35:58 GMT

Hello, Everyone!

I'm having some trouble with Set Analysis.

I'm trying to count products based on the last entry date on inventory, but there's a catch, I can't count products that arrived today or yesterday.
So far I got this:

Count(

{

[Date]={'$(=Max({1}Data))'},

[Inventory_Units]={0},

[Inventory_Units_DC]]={">0"},

[LastEntryDate]={"<$(Today()-1)"} <-- This part doesn't work, it seems like it's being ignored.

}

[Product]

)

Please ignore the others filters, they work!

I tried a lot of combinations on this part [LastEntryDate]={"<$(Today()-1)"}, but none them worked.

Best regards,
Breno

Re: Comparing Data Field with Today() Variable

andrey_krylov — Fri, 24 Aug 2018 06:50:30 GMT

First of all you need to put "=" in it

[LastEntryDate]={"<$(=Today()-1)"},

then if not enough you can try to play around with date format

[LastEntryDate]={"<$(=Date(Today()-1, 'DD.MM.YYYY'))"},

Re: Comparing Data Field with Today() Variable

ogautier62 — Fri, 24 Aug 2018 06:58:45 GMT

Hi,

maybe try this, it's working for me :

"<$(=date(today() -1))"

regards

Re: Comparing Data Field with Today() Variable

Anonymous — Fri, 24 Aug 2018 11:28:50 GMT

Hey, Olivier.

Thanks for the response, but is not working for me.
I even tried to take the other filters out to test, but it returns an error:

Re: Comparing Data Field with Today() Variable

Anonymous — Fri, 24 Aug 2018 11:34:57 GMT

Hello, Andrey.

Thanks for the response.

I tried this way too, I tried a lot of date formats, but none of them worked.

When I use the date field with no mask it returns this:

So I tried [LastEntryDate]={"<$(=Date(Today()-10, 'YYYY-MM-DD hh:mm:ss[.fff]'))"} to see it would change but no success. It still returns the max date ignoring the last entry date.

Re: Comparing Data Field with Today() Variable

andrey_krylov — Fri, 24 Aug 2018 18:34:19 GMT

Hi Breno, I did some tests and... Try this

[LastEntryDate]={"<$(=Date(Today()-10, 'YYYY-MM-DD hh:mm:ss.ffffff '))"}

Or maybe you can share you qvw

Re: Comparing Data Field with Today() Variable

Anonymous — Fri, 24 Aug 2018 18:51:26 GMT

Andrey,

It worked perfectly. Thank you so much!