Solved

Easy One!!! Add 15 days to this date

Posted on 2002-07-23
7
153 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 5

Accepted Solution

by:
Yog earned 150 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

Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

Question has a verified solution.

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

Suggested Solutions

One of the typical problems I have experienced is when you have to move a web server from one hosting site to another. You normally prepare all on the new host, transfer the site, change DNS and cross your fingers hoping all will be ok on new server…
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 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