Lotus Notes forms / views date issue

[testor15]

I am a long time programmer but very new to Lotus notes programming, tasked with a problem.  We have a form with a view allowing us to see all work projects created since the system was setup.  There is a need for a view to only show projects only after a set date, in this case '09/25/2009'.  The field name is CreateDate.  The form name is 'Proj'.

The form was created in 4.6 and I am using Lotus Designer 8.5.

The form structure for the CreateDate field is set to Date/Time, width '8', Display Date, year in 21st century, Show only month, day and year.

It appears I should be able to modify the view in the 'View Selection' to something like:
   SELECT ((Form = "Proj") & CreateDate > "09/25/2009")
I can't find a solution for this, any hints or help would be greatly appreciated.

[erbrooks]

You're close...

Dates in the @Formula language are wrapped in brackets []  not quotes "".  Quotes are used for strings (like FirstName = "John")

The width and display options on the form don't matter for the view, all that matters is that your documents (which in your case are your projects) have the field on them as a date.

So, assuming you and your server are in the US:

SELECT ((Form = "Proj") & CreateDate > [09/25/2009])

If you're not, or this is an international application then I would use the @Date function instead. E.g. [1/2/2009] means "January 1, 2009" for the US but "February 1, 2009" elsewhere.  If you need to worry about that then a more reliable alternative would be:

SELECT ((Form = "Proj") & CreateDate > @Date(2009;09;25))

[testor15]

Thank you! It worked perfectly!