Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
ksvaden1
New Contributor

Date Stamp for Report Run Date in NPrinting

I want to create a date field that will essentially be a date stamp of when the report was run.  I am trying to put this field into an NPrinting Excel Report right now but would be good to have for other NPrinting formats as well.  Any ideas?

Tags (3)
1 Solution

Accepted Solutions

Re: Date Stamp for Report Run Date in NPrinting

Well David

your formula is deducting one day from Today()

'Data as of ' & text(date(Today()-1,'MM/dd/yyyy'))


I would rather use:

'Data as of ' & text(date(Today(),'MM/dd/yyyy'))


And this would mean - current system date from the Qlik Server (taking into account timezone and time&Date setting of the Qlik server)


I would put this in NPrinting in formula like on the picture below:

2.png

Kimberly - you may also want to consider using Date(ReloadTime()) function - which would indicate when your Qlik application was reloaded, hence - it would indicate the actuall "As Of" for data you putting into report.



cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
7 Replies
dwforest
Valued Contributor

Re: Date Stamp for Report Run Date in NPrinting

I create a Formula field:

'Data as of ' & text(date(Today()-1,'MM/dd/yyyy'))

Chanty4u
Esteemed Contributor III

Re: Date Stamp for Report Run Date in NPrinting

where you want to see the Date format ?

reportname along with date?  or what exactly you need?

ksvaden1
New Contributor

Re: Date Stamp for Report Run Date in NPrinting

I just want to add a field in one cell to my nPrinting Excel Report that will stamp the day the report was run.  Hope that makes sense?  Let me know.  Thanks!

ksvaden1
New Contributor

Re: Date Stamp for Report Run Date in NPrinting

Thanks!  I will try this.  Sorry if this is a dumb question, I am new to Qlik.  Are you putting this field in QlikSense?  Or is it in NPrinting Excel?

dwforest
Valued Contributor

Re: Date Stamp for Report Run Date in NPrinting

Yes, create a Formula in the Editor as described and drop that into a cell.

Re: Date Stamp for Report Run Date in NPrinting

Well David

your formula is deducting one day from Today()

'Data as of ' & text(date(Today()-1,'MM/dd/yyyy'))


I would rather use:

'Data as of ' & text(date(Today(),'MM/dd/yyyy'))


And this would mean - current system date from the Qlik Server (taking into account timezone and time&Date setting of the Qlik server)


I would put this in NPrinting in formula like on the picture below:

2.png

Kimberly - you may also want to consider using Date(ReloadTime()) function - which would indicate when your Qlik application was reloaded, hence - it would indicate the actuall "As Of" for data you putting into report.



cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
dwforest
Valued Contributor

Re: Date Stamp for Report Run Date in NPrinting

Yes, what i said... our data is extracted up to yesterday, so for us the SOURCE data is as of that date.

If not able to understand what -1 means, turn back now and give up development.