Help...Using a >= date to determine data for view column

HCL Domino Domino Forum
1

I am trying to create a view that only brings back forms (named DefTicket) created after a certain date field (DateCreated) located on the form.

SELECT Form = “DefTicket” & ParentType!=“Converted to Child” & DateCreated >= 06/01/2007

I am using the code from above, but I am not getting any results back in the view. Any help would be appreciated!

2

Subject: Help…Using a >= date to determine data for view column

Hi Kelli,Try putting.

SELECT Form = “DefTicket” & ParentType!=“Converted to Child” & DateCreated >= [06/01/2007]

3

Subject: put date value within square brackets

SELECT Form = “DefTicket” & ParentType!=“Converted to Child” & DateCreated >= [06/01/2007]

Regards

Byju Joy

4

Subject: RE: put date value within square brackets

Thank you all so much, that seemed to do the trick!

5

Subject: RE: put date value within square brackets

Hi Kelly,try to use the simple action for creating complex view selection and once you create , change it to formula, so all the code is ready in the formula without any possible error.