Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to show some tickets count for yesterday that were logged from 8 am to 8 pm .
Can anybody suggest what expression should i use restrict time as such and display the same ?
May be this:
{<DateTimeField = {"$(='>=' & TimeStamp(DayStart(Today()) + 8/24) & '<=' &TimeStamp(DayStart(Today()) + 20/24))"}>}
Where DateTimeField is the same format as TimeStamp(DayStart(Today()) + 8/24)
Hi Sunny ,
Thanks for the help .
I have one more question .
If someone selects some dates and want the data to change accordingly and wants this 8 am to 8 pm time frame as default if he selects nothing ,then, Is there any way I can do so ?
Any help will be appreciated .Thanks
I think it's doable. Change Today() to a variable which is driven by user input from a input box may be