How can I count Dates in text format

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have this problem where the date fields are in text format, and I'm trying
to count the number of a person's work days.

Date Current Output Count Required Output Count
04/01/2005
04/01/2005
04/03/2005
04/04/2005
04/04/2005
5
3

Can I write a formula in the query to count on the day?

Any assistance will be appreciated.


.

Relevant Pages

  • Report recordset
    ... I tried both Format and print properties and finally fixed it with an update ... query. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Need help interpreting analysis of video files
    ... format and one from passthrough. ... Thanks for your assistance ... Prev by Date: ...
    (rec.video.desktop)
  • RE: How to isolate the day-value
    ... > In a program I am writing I need to isolate the day value from a date. ... > a date on the format dd.mm.yyyy, and need a formula in a query that returns ... Prev by Date: ...
    (microsoft.public.access.queries)
  • RE: filtering a result
    ... It may need the date entered in US format. ... "Bakr Z via AccessMonster.com" wrote: ... I want to add another query to filter the ... Prev by Date: ...
    (microsoft.public.access.queries)
  • text to dates?
    ... I have a problem with this following query: ... I have a list of cells in the text format: ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)