Date Query

Hi,

I want to display the object as day wise like

--> select select_date,task_name,task_description,hours_spent from ts_task_checklist where owner_name='xcpuser' and select_date =date('12/1/2011','mm/dd/yyyy')

when ever the objects are saved in that date, i want to retrive all the object for only one selected date .

I am try the above qery.

Thanking You.

Rajesh.c

Find more posts tagged with

Comments

Imran_Yusubov

so what is the problem?

rajesh.chebrolu@intueorinfotech.com

Hi Imran ,

I am very sorry i am able to get the result for that query , But for the same query i got the result when i executed for first 10 times. now i am not getting.

I will attach 3 screen short just look at once .

This one i got the result .

This one i didn't get the result for same query just after 10 min.

can please check it on the results are still their for this object type but . i changed query in date

this was the problem i am faceing can you please explain me y it happens.

Thanking you,

Rajesh.c

DCTM_Guru

Your first query has both bottom date AND top date:

task_date>date('12/23/2011') AND task_date<date(today)

so if today >= 12/24/2011, you would be able to satisfy both conditions

Your second query only has bottom date, so as long as task_date>date('12/23/2011') you will get results back that you see.

Julien.Fontaine

If you want to keep the same query try :

task_date>date(xxxx) and task_date<=date(today).

rajesh.chebrolu@intueorinfotech.com

HI Jony Gee,

Thanks for reply,

i need a query that can you modify according to me please.

The query i am getting the result

select task_date, sum(hours_spent)as hours_spent1 from ip_timesheet where task_date between date('"+starDate +"', 'mm/dd/yyyy') and date('"+endDate+"', 'mm/dd/yyyy') group by select_date

That means it is adding up the housr_spent that an employee worked on that date.Hear i am saving like for example

an employee spent on task one for 2hour , and on second task he spent on 4 hours , i am getting total hours on that day by the above query.

2)The porblem is i need to add some more attributes for this query like

select task_name,task_description,comments,task_date,task_name,work_description, sum(hours_spent)as hours_spent1 from ip_timesheet where task_date between date('"+starDate +"', 'mm/dd/yyyy') and date('"+endDate+"', 'mm/dd/yyyy') group by select_date

How can i modify the query to meet my requierments.

Thanking You,

Rajesh.c