Solved

How do you create dates for today, this week,this month and this year in cf8.

Posted on 2009-07-03
2
214 Views
Last Modified: 2013-12-24
How do you create dates for today, this week,this month and this year in cf8.

My code:
Experts :
I have a variable called leadframe being passed via cfdiv bind from form element leadframe.
the options are: today, thisweek,thismonth,thisyear
I understand how to set the variables i just don't know how to calculate the values.
I want to set startdate to the calendar date to begin query and enddate to end query.



<cfif leadframe EQ "today">
    <cfset startdate = "">
    <cfset enddate = "">
<cfelseif leadframe EQ "thisWeek">
      <cfset startdate = "">
       <cfset enddate = "">
<cfelseif startdate EQ "ThisMonth">
   <cfset startdate = "">
   <cfset enddate = "">
<cfelseif leadframe EQ "ThisYear">
     <cfset startdate = "">
     <cfset enddate = "">
</cfif>
 
Query:
 
Select * from mytable where date between startdate and enddate

Open in new window

0
Comment
Question by:LeadCo
2 Comments
 
LVL 13

Accepted Solution

by:
srikanthmadishetti earned 500 total points
ID: 24776590
For today keep the start and date coldfusion date fucntion now()
for all the other 3 here is the code:
 

<cfset dtcurrenttWeek = Fix( Now() )  />
                 
               
                <cfset objcurrentWeek = StructNew() />
                                <!--- Get start of week. --->
                <cfset objcurrentWeek.Start = DateFormat(dtcurrenttWeek - DayOfWeek( dtcurrenttWeek ) + 1
                ) />
                 
                <!--- Get end of week by adding to start date. --->
<cfset objcurrentWeek.End = DateFormat( objcurrentWeek.Start + 6 ) />
 
<cfoutput>
Week :<br>
#objcurrentWeek.Start# <br />
#objcurrentWeek.End#  <br>
</cfoutput>
 
 
<cfset objcurrentMonth = StructNew() />
 
 
<cfset yr=Year(Now())>
<cfset m=Month(Now())>
<cfset d=DaysInMonth(Now())>
<cfset objcurrentMonth.end=Createdate(#yr#,#m#,#d#)>
<cfset objcurrentMonth.start=Createdate(#yr#,#m#,01)>
 
<cfoutput>
Month : <br>
#Dateformat(objcurrentMonth.Start,"dd/mmm/yyyy")# <br />
#Dateformat(objcurrentMonth.End,"dd/mmm/yyyy")#  <br>
</cfoutput>
 
 
<cfset objcurrentYear = StructNew() />
 
 
<cfset yr=Year(Now())>
<cfset m=Month(Now())>
<cfset d=DaysInMonth(Now())>
<cfset objcurrentYear.end=Createdate(#yr#,01,01)>
<cfset objcurrentYear.start=Createdate(#yr#,12,31)>
 
<cfoutput>
Year :<br>
#Dateformat(objcurrentYear.Start,"dd/mmm/yyyy")#<br />
#Dateformat(objcurrentYear.End,"dd/mmm/yyyy")# <br>
</cfoutput>
 
 
Wrote this code long back :)) , Hope this helps
 Let me know if you need more help in this
0
 

Author Closing Comment

by:LeadCo
ID: 31599723
Thanks!
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question