Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

How do I display current date in report?

Locked
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

How do I display current date in report?

Unread post by JohnKlassen »

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
zazzium
Posts: 84
Joined: Mon Jul 04, 2011 12:52 am

Re: How do I display current date in report?

Unread post by zazzium »

I use this:

add

Code: Select all

DATE_FORMAT(CURDATE(),'%d.%m.%Y') AS add_date
to the report generator sql (%d.%m.%Y - set your preferred date format )

for example:

Code: Select all

CREATE TABLE #dataTable# SELECT *, DATE_FORMAT(CURDATE(),'%d.%m.%Y') AS add_date FROM invoice ...
add a field object named add_date to report design.

zazzium
JohnKlassen
Posts: 148
Joined: Wed Dec 05, 2012 4:56 am

Re: How do I display current date in report?

Unread post by JohnKlassen »

Hi,

That worked!

Thanks for your help.

John
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: How do I display current date in report?

Unread post by admin »

.
Locked