Working with dates in a view

HCL Domino Domino Forum
1

I need to create two separate views, one for docs where my EndDate field is greater than 90 days and the other when it’s less than 90 dyas.

Is there anyway to rewrite a formula like this to work?

SELECT Form = “MgrReports” & (EndDate < 90)

2

Subject: Working with dates in a view

The following assumes both fields are of type Date/Time and contain valid dates.

SELECT Form = “MgrReports” & ((EndDate - StartDate) / 86400) < 90)

All date math in Notes is done in seconds, and there are 86400 seconds in one day.

HTH,

Charles