topic Re: EXPRESSION HELP in App Development

EXPRESSION HELP

arusanah — Thu, 09 Aug 2018 19:02:08 GMT

Hi friends ,

I am trying to load date , for month end date or if it falls on Monday. so I created indicator e.g. in below example it works for Mondays but is not checking monthend () . I should see 0 next to 7/31 irrespective of fact that it Tuesday

=if([Date]=monthend([Date]) or date([Date],'wwww')='Monday' ,0,1)

Please help!

Re: EXPRESSION HELP

sunny_talwar — Thu, 09 Aug 2018 19:03:48 GMT

Try this

=If([Date] = Floor(MonthEnd([Date])) or Date([Snapshot Date], 'wwww') = 'Monday', 0, 1)

Re: EXPRESSION HELP

arusanah — Thu, 09 Aug 2018 19:23:43 GMT

Hi Sunny ,

As usual you are great help . Thank you so much !

Re: EXPRESSION HELP

arusanah — Fri, 10 Aug 2018 17:58:58 GMT

Is it possible to get only month date for completed months and "Mondays "only for current month?

e,g. 7/31/2018 & 8/6/2016 for above example

Re: EXPRESSION HELP

sunny_talwar — Fri, 10 Aug 2018 18:02:58 GMT

May be this

=If([Date] = Floor(MonthEnd([Date])) or (Date([Snapshot Date], 'wwww') = 'Monday' and MonthName(Today()) = MonthName([Snapshot Date]), 0, 1)

Re: EXPRESSION HELP

arusanah — Fri, 10 Aug 2018 18:14:27 GMT

Thank you Sunny !

Re: EXPRESSION HELP

sunny_talwar — Fri, 10 Aug 2018 18:15:13 GMT

Did you manage to resolve the issue in the script?

Re: EXPRESSION HELP

arusanah — Fri, 10 Aug 2018 18:18:32 GMT

Yes!

This user has been killing me with all U turns every few seconds .

Re: EXPRESSION HELP

arusanah — Fri, 10 Aug 2018 18:20:26 GMT

y am I not able to send to private messages ?