Datacard visible if month is current or previosus or next month

[pokhani]

hi Expert

is there way to set a visibility of data card if its current month is now or previous month or next month

[RandyHayes]

@pokhani 

Yes, but what are you comparing to?  What has the month?

[pokhani]

based on current month

[RandyHayes]

@pokhani 

Yes, but you are saying you want it visible if it is current month or previous or next month...compared to what??

With that logic it would always be visible unless you are comparing it to something!  A field value, a lookup, something!!

[pokhani]

hi 

these are the data card value and if i am in feb month than i can only see jan and march . all other should be hidden. 

[RandyHayes]

@pokhani 

Is there any logic to the month names in the labels, or are they just hand entered?

Things like...is the name of the datafield for that datacard the same (Jan, Feb, etc.)?

[pokhani]

no logic its simply the form field

[Gochix]

If(Month(storedVariable) = Month(Now()),true,false)

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[RandyHayes · Accepted solution]

@pokhani 

Well, then the logic for disabling would be very easy...EXCEPT, your month names are not consistent!  IN other words, you have Jan (the abbreviation for January), but then have March, May, July, etc...all full names.

So, factoring that in with the easy way (meaning that depending on ALL the names of your month columns/fields, this may or may not be successful), the formula in the Visible property of your Datacards would all be:

With({_ms: ForAll(Sequence(12), {Value: Index(Calendar.MonthsLong(), Value).Value, Month: Value}),
      _m: Month(Today())},
    With({_fm: LookUp(_ms, StartsWith(Value, Self.DataField)).Month},
        _fm=_m || _fm+1 = _m || _fm-1 = _m
    )
)

It would be a little shorter if your month and fieldNames were consistent.

I hope this is helpful for you.