[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

date always display 31 Dec 1899

Posted on 2004-10-30
2
Medium Priority
?
174 Views
Last Modified: 2013-12-24
Coldfusion MX
MS SQL 2000

Query:
<CFSET BEGINDATE = 0>

when try to output it displays:
<cfoutput>#begindate#</cfoutput>

the date always display 31 Dec 1899. What should i do, I am stuck.
Please let me know if you need complite code. There is no error.
0
Comment
Question by:matlowson
[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
2 Comments
 
LVL 21

Accepted Solution

by:
pinaldave earned 2000 total points
ID: 12455322
hello,
this is your problem
<CFSET BEGINDATE = 0>
When you do this it will always set it to 31 Dec 1899. As this is default value for windows or coldfusion

what date you want you should do soemthing like this...

<cfset begindate = now()>

you can also use dateforma from http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi59.htm#wp1103264
Regards,
---Pinal
0
 

Author Comment

by:matlowson
ID: 12460626
I guess I figured it out. Your answer helped me partially. Also no other expert have any comments here. I will close the question soon.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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…
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…
Suggested Courses

650 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