Creating a button with set analysis

[isciberras]

Hi can anyone help me please

I am trying to create a button with (Actions – Select in field).

I want the button to incorporate the following set analysis filter:

[day]={'Mon','Tue','Wed,''Thu','Fri'}, [time]={">06:45:00"}    as well as  [day]={'Sat','Sun'} without any time filter

Basically what I am trying to achieve is Monday to Friday only bringing back logs  greater than the following time: 06:45:00 as well as all logs on sat and Sunday irrelevant of a time filter.

Does anyone know if this is possible?

Thanks,

Isaac

[sunny_talwar]

Why don't you create a flag in the script like this

If(Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45), 1, 0) as Flag

and now use this in your button action

Field

Flag

Search String

1

[isciberras]

Thank you, that worked great however the part I'm struggling with is including Sat and Sun without any time filter, would you happen to have any ideas?

[sunny_talwar · Accepted solution]

May be this

If((Match(day, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri') and time > MakeTime(6, 45)) or Match(day, 'Sun', 'Sat'), 1, 0) as Flag

[isciberras]

You are a genius thank you so much for your help you always sole my problems when I'm completely stuck