Date Range Variable

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • troy_lee@comcast.net

    Date Range Variable

    How do I define a variable as a date range?

    Thanks in advance.

    Troy Lee
  • Tom van Stiphout

    #2
    Re: Date Range Variable

    On Wed, 4 Jun 2008 11:31:18 -0700 (PDT), troy_lee@comcas t.net wrote:

    I'm not sure I understand. A date range implies two dates, so that
    would take two variables:
    dim dtFrom as Date
    dim dtTo as Date

    I guess you could create a UDT = User Defined Type and combine the two
    variables.

    -Tom.

    >How do I define a variable as a date range?
    >
    >Thanks in advance.
    >
    >Troy Lee

    Comment

    • Roger

      #3
      Re: Date Range Variable

      On Jun 4, 12:31 pm, troy_...@comcas t.net wrote:
      How do I define a variable as a date range?
      >
      Thanks in advance.
      >
      Troy Lee
      dim strDate as string
      strDate = "between #6/1/08# and #6/30/08#"

      Comment

      Working...