User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 403,105 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,173 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our ColdFusion advertiser: Programming Forums

Posting News according to today's date

•
•
Join Date: Jun 2005
Posts: 15
Reputation: Torch7 is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 1
Torch7 Torch7 is offline Offline
Newbie Poster

Re: Posting News according to today's date

  #8  
Jul 27th, 2005
Okay...

Question... why is the end date significant are you attempting to syndicate.

IF StartDte and EndDte are both #CreateODBCDate(NOW())# Then it seems like the ENDDte is not necessary.

Try just

WHERE BeginDate = #DateFormat(Now())#

OR WHERE BeginDate = #CreateODBCDate(Now())#

Just to see how access responds to the query.

Note that the single quotes are not around the DateField...

I remember having this issue some time ago, and it was something very small, that had to do with access.
Reply With Quote  
Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 2:02 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC