add date

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cfmx2008
    New Member
    • Jan 2008
    • 36

    add date

    Hi,

    I have a date url.calldate. My calldate is like 05/01/08 and I want the values for 1 day after this day too. I used
    DateAdd("#url.c alldate#", 1, "mm/dd/yy")

    I receive error and I need your help.
  • acoder
    Recognized Expert MVP
    • Nov 2006
    • 16032

    #2
    DateAdd has the format:

    DateAdd("datepa rt", number, "date")

    Check the documentation.

    Comment

    • cfmx2008
      New Member
      • Jan 2008
      • 36

      #3
      Originally posted by acoder
      DateAdd has the format:

      DateAdd("datepa rt", number, "date")

      Check the documentation.

      so it should be:

      DateAdd("dd", 1 , "#url.calldate# ")

      Comment

      • acoder
        Recognized Expert MVP
        • Nov 2006
        • 16032

        #4
        No, that should be one "d", otherwise it looks fine.

        Comment

        • cfmx2008
          New Member
          • Jan 2008
          • 36

          #5
          Thank you so much. it works. your're great.

          Comment

          • acoder
            Recognized Expert MVP
            • Nov 2006
            • 16032

            #6
            No problem, you're welcome. Glad to help.

            Comment

            Working...