?
Solved

Easy One!!! Add 15 days to this date

Posted on 2002-07-23
7
Medium Priority
?
159 Views
Last Modified: 2013-12-24
I have a line:

<cfset querydate = #Month(Now())#/1/#Year(Now())#>

how do i add 15 days to it
0
Comment
Question by:jeffmace
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 5

Expert Comment

by:Yog
ID: 7172218
<cfoutput>
#DateAdd('D', '15', '#querydate#')#
</cfoutput>
0
 

Author Comment

by:jeffmace
ID: 7172234
Is this the best way to get the current month and year while always have 1 as the date?

<cfset querydate = #Month(Now())#/1/#Year(Now())#>
0
 

Author Comment

by:jeffmace
ID: 7172245
If I do this:

<cfset querydate = #Month(Now())#/1/#Year(Now())#>
#DateFormat(querydate, 'mmmm d, yyyy')#

It comes out as:
December 30, 1899
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 5

Accepted Solution

by:
Yog earned 600 total points
ID: 7172330
try CREATEDATE (year, month, day)

<cfset querydate = createdate(#Year(Now())#, #Month(Now())#, 1)>
<Cfoutput>
#Dateformat(format required)#
</cfoutput>
0
 

Author Comment

by:jeffmace
ID: 7172349
If I do this:

<cfset querydate = #Month(Now())#/1/#Year(Now())#>
#DateFormat(querydate, 'mmmm d, yyyy')#

It comes out as:
December 30, 1899
0
 

Author Comment

by:jeffmace
ID: 7172354
Thanks for your help.. I increased the points for you for taking the time.
0
 
LVL 5

Expert Comment

by:Yog
ID: 7172823
Jeff,

Thank you for the points, did it work. As such 100 pts are normal here, you dont have to spend more points for simple questions. if you dont have points and need help anytime, feel free to mail me at yog_23@hotmail.com :)

cheers.
yog
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Article by: kevp75
Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

764 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