All,
I have a date/time field .I need to filter on a specific time interval.
I extrcated only time fro mthe filed using time(date/time).
Now i need to display time between 9.00 am to 3.00 pm.
I used Time between '09:00:00 AM' and '03:00:00 PM' in the filter
But it did not work.
Also can i specify a time range based on some condition.(i.e based on data item).
for example if dataitem is working day then display tim erange between 9:00 and 3:pm.
Please advise.
cast the data item to the required format.
Should it be a string?I need a time interval.between 9:00 to 3:00?
Thanks in advance!
Some thing like this,
cast([ACTIVITY_TIME] as time) between cast(?StarTime? as time) and cast(?EndTime? as time)
or try converting to CHAR.
Thank you.
I am still not able to get the desired results because i am hard coding the time as '8:00:00 am'
All,
Can we compare a date time value with a string?example
if ([Dataitem1] = 'Business')
then( [time(Date/Time field] between '9:00:00' and 3:00:00)
else
if ([Dataitem1] = 'Office')
then( [time(Date/Time field] between '9:00:00' and 5:30:00)
else()
To achieve this should I cast it to char?What is the best way to achieve this result
Thanks in advance!
Can a string be compared with a date/time value with cast function?