Microsoft Office Forums - View Single Post - [Solved] Filtering past or future events in DRW query criteria

jvieille · 02-11-2006, 06:26 AM

I tried the following, which doen't work :

Included just bello the <head> tag :

<script language="JavaScript">

</script>

the query generated in FP webbot is :

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