Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Heading variables 1

Status
Not open for further replies.

slim2

Programmer
Oct 18, 2001
94
Can I have a variable field heading. I would like to have it like AMTmmyyyy where mm is month and yyyy is the year. Please help and let me know if this not possible.

Thanks
 
Let's say you are getting the "mm" and "yyyy" from a parameter called 'FieldDate' (format mm/dd/yyyy) then create a formula

@Date= month(FieldDate)+year(FieldDate)

then as your header, insert a text object with the contents

"AMT @Date" without the quotes
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top