Solved: Re: Date Stamp for Report Run Date in NPrinting - Qlik Community

Anonymous · ‎2018-04-20

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?

Lech_Miszkiewicz · ‎2018-04-20

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.

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.

View solution in original post

dwforest · ‎2018-04-20

I create a Formula field:

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

Chanty4u · ‎2018-04-20

where you want to see the Date format ?

reportname along with date? or what exactly you need?

Anonymous · ‎2018-04-20

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!

Anonymous · ‎2018-04-20

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 · ‎2018-04-20

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

Lech_Miszkiewicz · ‎2018-04-20

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.

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 · ‎2018-04-23

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.