I just figured out how to add a formula in Layout Designer that will print the start and end dates of the QuoteWerks contract.
"Contract Dates: "+text(documentheaders->contractstartdate)+ " to "+(text(documentheaders->contractenddate))
However, I would like to add an .if. statement that would only print this if the contractEndDate has a value.
I tried .if.documentheaders->contractenddate.then. and
.if.year(documentheaders->contractenddate)<>0.then.
Neither worked (I got Contract Dates: 00/00/00 to 00/00/00.
Any tips are welcome.
Both of the following work for me...
.if.text(documentheaders->contractenddate)=text("00/00/00").then. .if.documentheaders->contractenddate="00/00/00".then.
Thanks! I should have thought of that.
Gretchen Bren
I just figured out how to add a formula in Layout Designer that will print the start and end dates of the QuoteWerks contract.
However, I would like to add an .if. statement that would only print this if the contractEndDate has a value.
I tried .if.documentheaders->contractenddate.then. and
.if.year(documentheaders->contractenddate)<>0.then.
Neither worked (I got Contract Dates: 00/00/00 to 00/00/00.
Any tips are welcome.