M query and or

[Wishmaster89]

Hello

I have added an additional column that checks an id and date

if [Users.UserILRSummary_ULN]="3423916388" and  [ILR Aims.StartDate] = #datetimezone(2019, 10, 11, 0, 0, 0, 1, 0) then "Withdraw" else null

I want to check another Id and start date in the same column so i tried the following but it didn't work. Please help?

if [Users.UserILRSummary_ULN]="3423916388" or "5400297551"[Users.UserILRSummary_ULN]="3423916388"  and  [ILR Aims.StartDate] = #datetimezone(2019, 10, 11, 0, 0, 0, 1, 0) or  [ILR Aims.StartDate] = #datetimezone(2019, 01, 19, 0, 0, 0, 1, 0)then "Withdraw" else null

 

[XL Pro]

What about something like this:

if ([Users.UserILRSummary_ULN]="3423916388" and  [ILR Aims.StartDate] = #datetimezone(2019, 10, 11, 0, 0, 0, 1, 0)) or  ([Users.UserILRSummary_ULN]="5400297551" and  [ILR Aims.StartDate] = #datetimezone(2019, 01, 19, 0, 0, 0, 1, 0)) then "Withdraw" else null

 

[Wishmaster89]

@XL Pro , thank you that worked.