query with start date; between two dates

[stevesd]

I need to write a query that gives us a start date.
Will {Trans.TransDate} >= date (2000, 10, 20) give trans starting with Oct 20, 2000? And how to write a query that gets trans with TransDate between two specific dates?

 

[LV]

Assuming that you are building the record selection formula to pass to the report

1.
"{Trans.TransDate} >= date(2000,10,20)"
will get you all records statring with 10/20/2000

2.
"{Trans.TransDate} in date(2000, 10, 20) to date(2000,12,20)"
and you get all records falling into this range of dates.

Make sure that {Trans.TransDate} is Date data type

 

[MalcolmW]

Just to add emphasis to the last point of LV, not all databases have a date datatype (eg MS SQL Server has only datetime types), and quite often date fields in other databases are actually datetime. So be sure to check ;-) Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net