0

Scheduler and Copying Down Hidden Fields

Hi,

Normally when we do a report which will be scheduled, we use the NP("EVAL") formula on any fields that are copied down from hidden fields to avoid the #REF errors. For example, instead of "=F9", we use NP("EVAL","=F9") for numbers or NP("EVAL","="""&F9&"""") for text. In this case, I am copying down the Posting Date value, and neither of the NP("EVAL") formulas seem to work for a date. If I use NP("EVAL","=F9"), I get only the first value for date repeating for every row. If I use NP("EVAL","="""&F9&""""), I get the number value for the date (i.e. 43035) repeating the same value for every row. Does anyone know of another way to copy down date fields? 

Thanks!

8 comments

Please sign in to leave a comment.