topic Re: Date expression in App Development

Date expression

niranjana — Thu, 21 Sep 2023 06:42:59 GMT

Hi, I have a situation where I have date field "Movement date" in the date format "19/09/2023". i need to calculate count of claims.

I wrote this expression :

" count({$<[Movement Date]={"= $(Date(max([Movement Date])-1),'DD/MM/YYYY')"}>}[Claim Number]) " .

I also tried this expression : "count({$<[Movement Date]={"= $(=max([Movement Date]))"}>}[Claim Number])"

The expression shows ok, but the result is 0, or it doesn't show any result. The count must show as 2258.

Any help is appreciated.

Thanks in advance,

Niranjana

Re: Date expression

justISO — Thu, 21 Sep 2023 06:54:16 GMT

Hi, try this:

=count({$<[Movement Date]={"$(=(Date(max([Movement Date])-1,'DD/MM/YYYY')))"}>}[Claim Number])

Re: Date expression

niranjana — Thu, 21 Sep 2023 14:19:53 GMT

HI , Thanks a lot!! It worked..is it because of bracket?

Re: Date expression

justISO — Fri, 22 Sep 2023 06:02:11 GMT

I changed 2 parts, bracket place and this '{"= $(' part to '{"$(=(, but I don't know which change corrected the formula. I'll probably never learn to write set analysis correctly, so I always have a few examples saved to check syntax which works 🙂

Re: Date expression

niranjana — Sat, 23 Sep 2023 11:39:11 GMT

Thanks a lot! same issue is there...that of brackets.....ur explanation and having syntaxes is bang on!