Professional Web Applications Themes

Date Range - Coldfusion - Getting Started

I?ve got a routine that figure out 30 days from today?s date, but what I want to do is resolve a start date and an end date where the start date is the first day of last month and the end date is the last day of last month. Any ideas?...

  1. #1

    Default Date Range

    I?ve got a routine that figure out 30 days from today?s date, but what I want
    to do is resolve a start date and an end date where the start date is the first
    day of last month and the end date is the last day of last month. Any ideas?

    JMcDaniels Guest

  2. #2

    Default Re: Date Range

    Here you go!

    <cfscript>
    // set todays date
    Today = Now();

    // set first day of the month
    FirstOfMonth = CreateDate(Year(Today), Month(Today), 1);

    // set last day of month
    LastOfMonth = DateAdd("M", 1, FirstOfMonth);
    LastOfMonth = DateAdd("D", -1, LastOfMonth);
    </cfscript>

    Stressed_Simon Guest

  3. #3

    Default Re: Date Range

    You can also use:

    LastOfMonth =CreateDate(Year(Today), Month(Today), DaysInMonth(today));

    OldCFer Guest

  4. #4

    Default Re: Date Range

    Thanks, you guys are a big help.
    JMcDaniels Guest

Similar Threads

  1. Date Range Validation
    By CF_WISH in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: April 29th, 03:35 PM
  2. Date Range Search
    By TheScarecrow in forum Coldfusion - Advanced Techniques
    Replies: 3
    Last Post: March 24th, 07:18 PM
  3. Date Range from Week Number
    By Unamailer in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: March 8th, 09:24 PM
  4. HELP - Moving Files By Date Range
    By Jeff in forum Linux / Unix Administration
    Replies: 2
    Last Post: November 21st, 07:19 AM
  5. date range query
    By shau in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 11th, 10:47 AM

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