Hi,
I have created a letter using report builder. The letter gets data from 4 different tables. The only thing left is displaying the current date in the report.
I am familiar with creating a label containing '=NOW()' in the report but that displays the current date AND time. I want to only display the current date.
Any suggestions?
Thanks,
John
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
How do I display current date in report?
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am
-
- Posts: 84
- Joined: Mon Jul 04, 2011 12:52 am
Re: How do I display current date in report?
I use this:
add to the report generator sql (%d.%m.%Y - set your preferred date format )
for example:
add a field object named add_date to report design.
zazzium
add
Code: Select all
DATE_FORMAT(CURDATE(),'%d.%m.%Y') AS add_date
for example:
Code: Select all
CREATE TABLE #dataTable# SELECT *, DATE_FORMAT(CURDATE(),'%d.%m.%Y') AS add_date FROM invoice ...
zazzium
-
- Posts: 148
- Joined: Wed Dec 05, 2012 4:56 am