HI ,
i have an custom object type in which i have an attribute like (task_name( String ),task_description( String ),task_date( Time ).)
1) i want to retrive the object type based on task_date of the same which i was saved on a pirticular day.
i am try this query . but i am not getting the result
example: select task_date,task_name,work_description,hours_spent from ip_timesheet where task_date>=date('12/27/20011 00:01:00','mm/dd/yyyy HH:MM:SS') and task_date<date(''12/27/20011 23:59:00','mm/dd/yyyy HH:MM:SS'');
But for this query i am geting the result when only it match to today's day only
example : select task_date,task_name,work_description,hours_spent from ip_timesheet where task_date>=date('12/23/20011 00:01:00','mm/dd/yyyy HH:MM:SS') and task_date<date('TODAY')
But insted of giving (TODAY) i need to spceify a date ;
please can any one help me in isseu.
Thanking You,
Rajesh.c
