Isolating date part of date / time variable
I have a date / time variable declared in a form. I am using it's data entry from a calendar view such that both date and time info is input to the variable which is called 'sched_time'. I want to show a grid view of today's records from the form called 'Case' and have attempted to use the criteria as below in the view script.
show all rows from Case [sched_time == zoho.currentdate]
This does not work and no records are ever shown using this format. I have tried to use combinations of some date functions like getdate, but apparently these only work on strings.
I need something like
show all rows from Case [datevalue(sched_time) == zoho.currentdate]
Maybe I could convert the date/time to a string, then concatenate the month day year then use <string>.todate(string_var) but that seems quite awkward.
BTW, I'm sure that at some point I will need to isolate the time portion of the date/time as well.
Any ideas?