Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing/ignoring time in a date time field
I have data from a DB that I am working with. The transaction time is in
date, time format. when I want to run a function against this data =sumproduct((date=x)*(issue=Y)*(status=z)) I would like to be able to query against a date (24 hour period) unfortunately 7/17/2008 does not = 7/17/2008 01:00:54. is there a way to ingnore the time stamp so that I can query the data and pull all data on a specific date. Thanks Jeff -- Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing/ignoring time in a date time field
Instead of date=x, you can try
=IF(TEXT(date,"mmmm-dd-yyyy")=TEXT(x,"mmmm-dd-yyyy"),1,0) -- John C "Jeff" wrote: I have data from a DB that I am working with. The transaction time is in date, time format. when I want to run a function against this data =sumproduct((date=x)*(issue=Y)*(status=z)) I would like to be able to query against a date (24 hour period) unfortunately 7/17/2008 does not = 7/17/2008 01:00:54. is there a way to ingnore the time stamp so that I can query the data and pull all data on a specific date. Thanks Jeff -- Jeff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
removing/ignoring time in a date time field
So how would that apply to a named range?
I am looking through several hundred rows of data and trying to get a count of issues on a certain date. if the range name=Date how does that work into the formula below? Thanks Jeff -- Jeff "John C" wrote: Instead of date=x, you can try =IF(TEXT(date,"mmmm-dd-yyyy")=TEXT(x,"mmmm-dd-yyyy"),1,0) -- John C "Jeff" wrote: I have data from a DB that I am working with. The transaction time is in date, time format. when I want to run a function against this data =sumproduct((date=x)*(issue=Y)*(status=z)) I would like to be able to query against a date (24 hour period) unfortunately 7/17/2008 does not = 7/17/2008 01:00:54. is there a way to ingnore the time stamp so that I can query the data and pull all data on a specific date. Thanks Jeff -- Jeffs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing date from time | Excel Discussion (Misc queries) | |||
Ignoring Time in a Date Time Calculation | Excel Worksheet Functions | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Drop time in date/time field | Excel Worksheet Functions | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |