If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running a Query Date
There is a field in a table that give a date time stamp. I want to be able
to do a query on just the date part of the field. Is there a way to extract just the date and not the time. Or can you separte the two by using a query into two seprate fields. The field is called "Status Change" The format is "Short Date" (only to display This is what is in the field: 5/9/2007 8:25:30 AM Just to give you background. I am running the report from a call center program. Then importing the data for the day into access to run reports. So it gives me the field in date time. You can't seprate it in the call center program. |
#2
|
|||
|
|||
Running a Query Date
Kat,
Use the DateValue( ) function. There is also a TimeValue( ) function if you want to strip out just the time. HTH Dale -- Email address is not valid. Please reply to newsgroup only. "Kat" wrote: There is a field in a table that give a date time stamp. I want to be able to do a query on just the date part of the field. Is there a way to extract just the date and not the time. Or can you separte the two by using a query into two seprate fields. The field is called "Status Change" The format is "Short Date" (only to display This is what is in the field: 5/9/2007 8:25:30 AM Just to give you background. I am running the report from a call center program. Then importing the data for the day into access to run reports. So it gives me the field in date time. You can't seprate it in the call center program. |
#3
|
|||
|
|||
Running a Query Date
I have never done that. Can you give me an example?
"Dale Fye" wrote: Kat, Use the DateValue( ) function. There is also a TimeValue( ) function if you want to strip out just the time. HTH Dale -- Email address is not valid. Please reply to newsgroup only. "Kat" wrote: There is a field in a table that give a date time stamp. I want to be able to do a query on just the date part of the field. Is there a way to extract just the date and not the time. Or can you separte the two by using a query into two seprate fields. The field is called "Status Change" The format is "Short Date" (only to display This is what is in the field: 5/9/2007 8:25:30 AM Just to give you background. I am running the report from a call center program. Then importing the data for the day into access to run reports. So it gives me the field in date time. You can't seprate it in the call center program. |
#4
|
|||
|
|||
Running a Query Date
In the query grid view:
Field: JustTheDate: DateValue([Status Change]) '================================================= === John Spencer Access MVP 2002-2005, 2007 Center for Health Program Development and Management University of Maryland Baltimore County '================================================= === Kat wrote: I have never done that. Can you give me an example? "Dale Fye" wrote: Kat, Use the DateValue( ) function. There is also a TimeValue( ) function if you want to strip out just the time. HTH Dale -- Email address is not valid. Please reply to newsgroup only. "Kat" wrote: There is a field in a table that give a date time stamp. I want to be able to do a query on just the date part of the field. Is there a way to extract just the date and not the time. Or can you separte the two by using a query into two seprate fields. The field is called "Status Change" The format is "Short Date" (only to display This is what is in the field: 5/9/2007 8:25:30 AM Just to give you background. I am running the report from a call center program. Then importing the data for the day into access to run reports. So it gives me the field in date time. You can't seprate it in the call center program. |
#5
|
|||
|
|||
Running a Query Date
Kat,
Per your request. Select [Status Change], DateValue([Status Change]) as JustTheDate From yourTable Or, to select all of the records that were entered in yourTable today, Select * FROM yourTable WHERE DateValue([Status Change]) = Date() HTH -- Email address is not valid. Please reply to newsgroup only. "Kat" wrote: I have never done that. Can you give me an example? "Dale Fye" wrote: Kat, Use the DateValue( ) function. There is also a TimeValue( ) function if you want to strip out just the time. HTH Dale -- Email address is not valid. Please reply to newsgroup only. "Kat" wrote: There is a field in a table that give a date time stamp. I want to be able to do a query on just the date part of the field. Is there a way to extract just the date and not the time. Or can you separte the two by using a query into two seprate fields. The field is called "Status Change" The format is "Short Date" (only to display This is what is in the field: 5/9/2007 8:25:30 AM Just to give you background. I am running the report from a call center program. Then importing the data for the day into access to run reports. So it gives me the field in date time. You can't seprate it in the call center program. |
Thread Tools | |
Display Modes | |
|
|