Select fields with specific date & time?

HCL Domino Domino Forum
1

Hi, how can I select only fields with a specific date & time set through a select statement in lotus script, please?

I’ve tried this (customDate is a datetime field):

Select (@GetField ( “customDate” ) = “04/23/2004 12:00:00 AM”);

It returns nothing even though there is at least one customDate field with this specific date and time.

Thanks

2

Subject: Square brackets for date/time

Formula language date/time literals are denoted by square brackets. Your statement is attempting to compare a string literal with the date/time value from the field. Try this:

Select customDate = [04/23/2004 12:00:00 AM];

or

Select (@GetField ( “customDate” ) = [04/23/2004 12:00:00 AM]);