How to show variable when WeekFlag is 1

[ashmitp869]

Hi there,

I want to show vWeekStart as 27/9/2021 and vWeekEnd as 3/10/2021 without any selection from the table below.

when the app is open....

How to show the vWeekStart when the WeekFlag is 1.

[MayilVahanan]

HI 

Try like below

vWeekStart  = Date(Min({<WeekFlag ={1}>}MDate))

vWeekEnd = Date(Max({<WeekFlag ={1}>}MDate))

[NageshSG · Accepted solution]

Hi @ashmitp869 

You can set the variable expression as under:

vWeekStart=Max({$<WeekFlag={1}>}MDateWeekStart)
vWeekEnd=Max({$<WeekFlag={1}>}MDateWeekEnd)

Additionally, In case you want to ignore the user selection of the dates in the front end, replace the '$' above with '1' as the identifier inside the set expression above.