comparing date and string values

From: Virgil (anonymous_at_discussions.microsoft.com)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 06:35:52 -0700

Since Access apparently has no way to convert strings to
dates (or am I mistaken?), what's the best way to compare
values between the two data types? The string value is in a
date format.

Relevant Pages

  • Re: A note on computing thugs and coding bums
    ... Here's my response including a bug fix. ... to make "modern strings" possible was designed and first implemented ... contents to strings, to compare them, and to duplicate them. ... while the Pike code will NEVER work...for international strings. ...
    (comp.programming)
  • RE: Exclude date
    ... You are here comparing strings and not dates and that is the reason of the ... So the solution would be or to use a format whit which the operators ... conver the user input to a date value and compare the dates as dates not as ... Dim lngLastRow As Long ...
    (microsoft.public.excel.programming)
  • Re: Ascan with a Substr
    ... the above suggestion: ... operator to compare the strings. ... code block you originally used was just right, ...
    (comp.lang.clipper)
  • Re: Ascan with a Substr
    ... The following solution work well ... operator to compare the strings. ... code block you originally used was just right, ...
    (comp.lang.clipper)
  • Re: almost equal strings
    ... Those are good for comparing words, or arbitrary strings, as Roedy asked, but he reveals that he actually wants to compare phrases. ... You might need a more refined scoring method, though - not all insertion, deletions or substitutions are of equal importance. ... Anyway, i don't think cljp is the place to ask about this - there is a huge body of knowlege about text processing which Roedy could tap into, and there must be a place to ask questions on it. ...
    (comp.lang.java.programmer)