Professional Web Applications Themes

How can i set a startdate 12 month's in the past - Coldfusion - Advanced Techniques

I would like to have an startdate, the month, 12 months in the past as to the today's month. This is the have the charts generated without entering dates. De current date format on my access database is medium long . dd-mmm-yy. Today, two dates need to be entered. 1, the startdate = 12 months back in time. 2, the enddate = today's month. Would be great if some one could tell me how to do this. Thanks...

Sponsored Links
  1. #1

    Default How can i set a startdate 12 month's in the past

    I would like to have an startdate, the month, 12 months in the past as to the
    today's month.
    This is the have the charts generated without entering dates.
    De current date format on my access database is medium long . dd-mmm-yy.

    Today, two dates need to be entered. 1, the startdate = 12 months back in time.
    2, the
    enddate = today's month.
    Would be great if some one could tell me how to do this.
    Thanks

    Sponsored Links
    whatsaname Guest

  2. #2

    Default Re: How can i set a startdate 12 month's in the past

    <cfset aYearAgosDate = DateAdd('m',-12,now())>

    <cfset startYear = year(aYearAgosDate)>
    <cfset startMonth = month(aYearAgosDate)>
    <cfset endYear = year(now())>
    <cfset endMonth = month(now())>
    Kronin555 Guest

  3. #3

    Default Re: How can i set a startdate 12 month's in the past

    The code you seek is the DateAdd function;

    #DateFormat('#DateAdd('m',-12,Now())#','dd/mmm/yy')#

    Where m is month and -12 is 12 months ago. This will actuallay out put
    08/Nov/04 (if used today) in the format you are using.

    bigbrain28 Guest

  4. #4

    Default Re: How can i set a startdate 12 month's in the past

    Thanks for your help.
    whatsaname Guest

Similar Threads

  1. where DATE is BETWEEN startdate and enddate...how?
    By Nathon Jones in forum Dreamweaver AppDev
    Replies: 9
    Last Post: March 8th, 01:44 PM
  2. HIDE IF startdate is the same as enddate
    By Nathon Jones in forum Dreamweaver AppDev
    Replies: 2
    Last Post: March 8th, 12:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139