Setting up a 60 day flag - System MonitorLoad

[#1]

Hi

I have a field in an application to which I need to add a FLAG (1/0) that checks is a Session Date is less or greater than 60 days since the last access.

The rule for the flag is if(Session_Date) >= 60 than Flag = 1 and if(Session_Date) <60 than Flag = 1.

My Session_Date is declared as -
MakeDate(Year([Session Start]),Month([Session Start]),Day([Session Start]))              AS Session_Date

Thanks

S

[maxgro · Accepted solution]

// maybe you have to swap 0 and 1

if( [Session Start] > (Today(0)-60) and [Session Start] < (Today(0)+60),1,0) as FlagDate,

[#3]

Thanks that flag seems to give a 60 day flag of user access