Changing text field to Date


I am linking to a text file and I need to change the date field "Posting
Date" to a Date type. I am trying to use this code that I found on this
site:
Expr1: Format(CDate([Posting Date]),"mm/dd/yyyy"), but it doesn't work
correctly when I try to sort by the date, it is sorting like the date
field is still text (06/01/2008 is below 07/01/2008, when sorted
decending).
Thanks in advance.
Sean




--
metalone
.

Relevant Pages

  • Re: LDAP running on Window CE device always returning LDAP_LOCAL_E
    ... Thank you for responding to my posting. ... The linking arguments were ... Is there any conditions in DllMain() ... DLL_PROCESS_ATTACH that could circumvent LdapClientInitialize? ...
    (microsoft.public.windowsce.embedded.vc)
  • Re: Basic Scripts for Database Administration
    ... another way to drive search traffic to his site, often linking to it ... himself in various online posts. ... I was most bloggled by his posting of ...
    (comp.databases.oracle.server)
  • undefined reference to __udivdi3 (gcc-4.3)
    ... the following error occurs during linking: ... Searching the archives brought up old issues with gcc-3.4 and not so old posting from 01/2008, but I could not find a solution include libgcc.a). ...
    (Linux-Kernel)
  • Re: New hawk pic for identification
    ... although sometimes the guessing is fun...... ... If I went thru the trouble of posting and linking to find out what ...
    (rec.birds)