Syntax to evaluate multiple values pass from parameter

[Former Member]

A time parameter with static list has been set to allow multiple value selection.

If only one value is selected then following syntax works for record selection

{Assignment_.SCHED_START_TIME}= DateTime ({?Date},{?Start Time} )

But it does not work for multiple values. What should the formula be to evaluate multiple values?

[Former Member · Accepted solution]

Hi Binit,

Try this:

{Assignment_.SCHED_START_TIME} IN DateTime ({?Date},{?Start Time} )

- Nrupal

[Former Member · Accepted solution]

Nrupal -

I tried that and it highlights DateTime ({?Date},{?Start Time} ) and says date-time range required.

[Former Member · Accepted solution]

Hi Binit,

Is there going to be another parameter for end time?

[abhilash_kumar · Accepted solution]

Try:

Time({Assignment_.SCHED_START_TIME}) IN ({?Start Time})

AND

Date({Assignment_.SCHED_START_TIME}) = {?Date}

-Abhilash

[Former Member · Accepted solution]

Hi Binit,

I missed that you are using 2 parameters.

Try Abhilas's suggestion.

- Nrupal

[Former Member · Accepted solution]

Abhilash -

I tried that and it highlights

Time({Assignment_.SCHED_START_TIME}) IN ({?Start Time})

AND

Date({Assignment_.SCHED_START_TIME}) = {?Date}

and says time range required. Note, previously it mentioned date-time range required.

Should an array be used to store multiple values?

What more information can I provide you to solve this?

[abhilash_kumar · Accepted solution]

What is the datatype of the {Assignment_.SCHED_START_TIME} field?

-Abhilash

[Former Member · Accepted solution]

It's date and time, example 2014-07-07 21:00:00.000