Checking for time interval?

[xoomaster]

Sorry guys, but I am new to this forum.

My question is :

I have a time, say 7:20 AM and want to see if it is within a rage of

{7:00 am..10:00 am} . Am I missing something or there is a easy way of doing this in a script step.

Thank you

Xoomaster

[hbrendel]

Three fields:

Time (time) your questioned time

StartTime (time) here you put the 7:00 value

EndTime (time) here you put the 10:00 value

Script:

If [TableName::Time >= TableName::StartTime and TableName::Time <= TableName::EndTime]

Show Custom Dialog ["Check"; "Yes!!"]

Else

Show Custom Dialog ["Check"; "Well eh ... no."]

End If

[LaRetta]

You shouldn't need any additional fields for this. It can all be handled within the script using a boolean test. Script step:

If [ Hour ( timeField ) ≥ 7 and Hour ( timeField ) ≤ 10 ]

... do whatever if yes

LaRetta :wink2:

[hbrendel]

You shouldn't need any additional fields for this

Just to make it possible to do other time ranges. :

[xoomaster]

thank you guys and girls.