Blank Year in On Demand PDF

[#1]

I have a formula in NPrinting that displays the date correctly in edit mode, but when I run the report in On Pemand the PDF shows the Year as blank.  Any ideas?

[#2]

The formula is :  ='Snapshot Date = '& [Snapshot Date Select] & '      Usage Year = ' & [Usage Year Select]& '      Usage Months = ' & min([Usage Mon Name]) &' - ' &max([Usage Mon Name])

[Anonymous]

What template type are you using?   If you choose that template in On-Demand instead of PDF does it work?

I am assuming you are placing your calculated formula in a text box.  Is it possible the date is too big to fit in the space you have allocated.  Is there a carriage return in there accidentally?

[#4]

I was using the excel template. The date does not display correctly when I do a preview in NPrinting which is in excel format.

Gary Westman | Developer – MLT Data Warehouse

Delta Air Lines | 1500 Towerview Road | Department 114 | Eagan, MN 55121

651.289.8551

[#5]

I am using a formula and dropping into an excel cell. Other formulas without dates are working fine.

Gary Westman | Developer – MLT Data Warehouse

Delta Air Lines | 1500 Towerview Road | Department 114 | Eagan, MN 55121

651.289.8551

[#6]

This is odd. I added another formula to the row =today() and the other date values are now displaying on the other formula. Unfortunately the =today() cell shows 42381 instead of todays date.

Gary Westman | Developer – MLT Data Warehouse

Delta Air Lines | 1500 Towerview Road | Department 114 | Eagan, MN 55121

651.289.8551

[Anonymous]

Your answer means you likely don't have an on demand problem.

If you go to your QV app and create a text box, does your formula show you the desired result?

You may need to create your formula using a variable in QV and then place it in your output in Excel.

[#8 · Accepted solution]

If you format that cell be be a date field, it will convert it to the date format you select

[Anonymous]

=date(today(),'MM/DD/YYYY')  will fix the date issue