Skip to main content
Question

How do you display/print the Current Date on a report created using Web Report Designer

  • October 13, 2025
  • 7 replies
  • 81 views

Forum|alt.badge.img+9
  • Participating Frequently

I’d like to print the printed date on a Contract and can’t find how to.

Anyone know?

7 replies

Jpolley
Forum|alt.badge.img+14
  • Participating Frequently
  • October 13, 2025

@keithw  i have not tried new report designer, but this code worked for me before to put “Today’sDate” as text in the contract.

[PrintDate!MM/dd/yy]


Forum|alt.badge.img+9
  • Author
  • Participating Frequently
  • October 13, 2025

Thanks for the reply ​@Jpolley.

I couldn’t get that to work.

I’m creating a custom field “OpportunityProposalContractDate” to show:
-  just the Opportunity Date for won opportunities, or
- the text “Proposal Date: “ followed by the current date (the date printed)

It looks like (in the Expression Editor) there are several options  - GetDate(), etc. - but I can’t find any support for putting text and a formatted date together.  I can get “Proposal Date: 10/03/2025 00:00:00” but I don’t need the time data.

Thanks for your suggestion though.


Jpolley
Forum|alt.badge.img+14
  • Participating Frequently
  • October 13, 2025

@keithw Sorry, I should have said to replace PrintDate! with whatever date data field you are working with. You can update the text once you add the data field in and update formatting code  [OpportunityProposedDate!MMMM d, yyyy] will look like 

[OpportunityProposedDate!MM/dd/yy]

 


Forum|alt.badge.img+9
  • Author
  • Participating Frequently
  • October 14, 2025

Thank you again @jpolley.

I think my original post might be confusing.  I just want to print the current date on a report.

I don’t think it’s a data field?

I am assuming it’s one or a combination of the Web Report Designer Functions:

GetDate()

LocalDateTimeToday()

Today()

I’ll plan on trying at least those three with your suggested code and see if I can get things to work.


Kbaird
Forum|alt.badge.img+17
  • Inspiring
  • October 29, 2025

I’ve got the answer! 

  1. Click the fields list
  2. Create new calculated field in the spReportOpportunityHeader (I called mine TodaysDate
  3. Call the field TodaysDate
  4. in the expression put Now()
  5. Format as DateTime
  6. use [TodaysDate!mmddyyy] etc. to set how it displays as a token!

Forum|alt.badge.img+9
  • Author
  • Participating Frequently
  • October 29, 2025

Awesome ​@Kbaird!  Thank you Thank you!

I have one question.  Re: #6:  Where do you [how do you] “use” the formula? In Design Properties?

I set the Text Format String in Design Properties to “{0:M/d/yyyy}” to get “10/29/2025”.
Is that what you mean?
___
“I love it when a plan comes together.”  Hannibal Smith - The A-Team 😁


Kbaird
Forum|alt.badge.img+17
  • Inspiring
  • October 30, 2025

Anything in square brackets is called a token or field. You can use these in-line. So, you can be typing in a label and say: “This opportunity was printed on [TodaysDate] which will give you the long form with hours, minutes and seconds. You can append a “!” within the brackets but after the token and then use that to format the token. [TodaysDate!yyyy] would give you just the year. etc. You can also use this to format currency in-line.