Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

LinkBack Thread Tools Display Modes
Old 02-11-2006, 01:15 AM
Join Date: Feb 2006
Posts: 2
Default Filtering past or future events in DRW query criteria

I use DRW to display an ordered calendar of event in table from an Excel spreadsheet.

I wish now to present these events in 2 table,
- one displaying past events since now
- one displaying future events from now
I hoped I could just compare the date filed to the current system date, but it does not apear to be so easy
- I did not find such ready to use built-in system variable, nor I found how to easily create it
- Id did not found any simple way to compare a field content with a variable content instead of a hard coded value.
I use FP 2003

Thanks for help
Reply With Quote
Old 02-11-2006, 06:26 AM
Join Date: Feb 2006
Posts: 2

I tried the following, which doen't work :

Included just bello the <head> tag :

<script language="JavaScript">
var CurrentDate = new Date();
// -->

the query generated in FP webbot is :

fp_sQry="SELECT * FROM ""Planning"" WHERE (Date IS NOT NULL AND Date < '::CurrentDate::') ORDER BY Date ASC"
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering out CC's arzsupra Outlook 0 03-11-2008 05:55 PM
Outlook calender events not bolded muaddib Outlook 0 10-06-2006 05:47 AM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM
Multiple criteria in SUMIF? pumpkin head Excel 1 02-17-2006 09:06 AM
Outlook reminders for non-existing events RDeBord Outlook 2 01-21-2006 07:47 AM

All times are GMT -7. The time now is 11:50 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft