Dunton David Software Solutions Engineer

Thats what I needed! Thanks to both of you.

I have one autoindex to set the value and another to remove it.

Tested and working.

SELECT
      DWDOCID
FROM BOOKINGDEALS
WHERE DATEPART(m, ContractDate) = DATEPART(m, CAST(GETDATE()AS Date)) -1
      AND DATEPART(yyyy, ContractDate) = DATEPART(yyyy, (DATEADD(m, -1, GETDATE())))

;

SELECT
      DWDOCID
FROM BOOKINGDEALS
WHERE DATEPART(m, ContractDate) = DATEPART(m, CAST(GETDATE()AS Date)) -2
      AND DATEPART(yyyy, ContractDate) = DATEPART(yyyy, (DATEADD(m, -2, GETDATE())))
      AND Status = 'PREVIOUSMONTH'

https://www.docuware.com/forum/english-forums/docuware-help-technical-pr...

Looks like Free SQL Statements aren't available in Cloud, unless i'm missing something.

Thanks.

Thanks Phil, i'll keep trying.

Thank you for the quick reply.

I tried both of those, recieved a "Wrong condition!" error.

https://www.docuware.com/sites/default/files/forums-images/2018-04-23%2013_25_38-DocuWare.png

https://www.docuware.com/sites/default/files/forums-images/2018-04-23%2013_26_06-Configurations.png

Looking to "Configure a List" where date=previous calendar month. IE, if the current month is June, then display May results.

Is this possible? The "Within the past" is a number of days if i choose month, thus showing the wrong results.

I've played with the "Is (Where Clause)", without any luck.

This is for a cloud system, so SQL Statements are out of reach.