topic Date Stamp for Report Run Date in NPrinting in Qlik NPrinting

Date Stamp for Report Run Date in NPrinting

Anonymous — Wed, 25 Sep 2019 18:40:54 GMT

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?

Re: Date Stamp for Report Run Date in NPrinting

dwforest — Fri, 20 Apr 2018 17:41:14 GMT

I create a Formula field:

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

Re: Date Stamp for Report Run Date in NPrinting

Chanty4u — Fri, 20 Apr 2018 17:42:16 GMT

where you want to see the Date format ?

reportname along with date? or what exactly you need?

Re: Date Stamp for Report Run Date in NPrinting

Anonymous — Fri, 20 Apr 2018 18:46:50 GMT

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!

Re: Date Stamp for Report Run Date in NPrinting

Anonymous — Fri, 20 Apr 2018 19:02:17 GMT

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?

Re: Date Stamp for Report Run Date in NPrinting

dwforest — Fri, 20 Apr 2018 20:03:52 GMT

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

Re: Date Stamp for Report Run Date in NPrinting

Lech_Miszkiewicz — Sat, 21 Apr 2018 00:44:12 GMT

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:

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.

Re: Date Stamp for Report Run Date in NPrinting

dwforest — Mon, 23 Apr 2018 17:37:17 GMT

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.