EXPRESSION HELP

[arusanah]

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!

[sunny_talwar · Accepted solution]

Try this

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

[arusanah]

Hi Sunny ,

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

[arusanah]

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

[sunny_talwar]

May be this

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

[arusanah]

Thank you Sunny !

[sunny_talwar]

Did you manage to resolve the issue in the script?

[arusanah]

Yes!

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

[arusanah]

y am I not able to send to private messages ?