M MBM Registered User. Local time Today, 05:20 Joined Sep 27, 2010 Messages 31 May 4, 2011 #1 I've created a letter but cannot get the date to display e.g. We received you letter on " & ([now()-7]) & " or : We received you letter on " & ([=now()-7]) & " Brings up an 'Enter Parameter Value' dialog box.
I've created a letter but cannot get the date to display e.g. We received you letter on " & ([now()-7]) & " or : We received you letter on " & ([=now()-7]) & " Brings up an 'Enter Parameter Value' dialog box.
B Beetle Duly Registered Boozer Local time Yesterday, 22:20 Joined Apr 30, 2011 Messages 1,807 May 4, 2011 #2 Where are you attempting to put this? In the Control Source of a Form or Report Control? Then; ="We received your letter on " & Date()-7 In a calculated field in a query? Then; Message: "We received your letter on " & Date()-7
Where are you attempting to put this? In the Control Source of a Form or Report Control? Then; ="We received your letter on " & Date()-7 In a calculated field in a query? Then; Message: "We received your letter on " & Date()-7
M MBM Registered User. Local time Today, 05:20 Joined Sep 27, 2010 Messages 31 May 4, 2011 #3 Beetle said: Where are you attempting to put this? In the Control Source of a Form or Report Control? Then; ="We received your letter on " & Date()-7 In a calculated field in a query? Then; Message: "We received your letter on " & Date()-7 Click to expand... Control Source. Thanks this worked : " & Date()-7 & " Last edited: May 4, 2011
Beetle said: Where are you attempting to put this? In the Control Source of a Form or Report Control? Then; ="We received your letter on " & Date()-7 In a calculated field in a query? Then; Message: "We received your letter on " & Date()-7 Click to expand... Control Source. Thanks this worked : " & Date()-7 & "
