Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
// maybe you have to swap 0 and 1
if( [Session Start] > (Today(0)-60) and [Session Start] < (Today(0)+60),1,0) as FlagDate,
// maybe you have to swap 0 and 1
if( [Session Start] > (Today(0)-60) and [Session Start] < (Today(0)+60),1,0) as FlagDate,
Thanks that flag seems to give a 60 day flag of user access