archiving

[raadwiptec]

Hi all,

I would want to have a chart archived to a QVD based on a specific dates automated?

[raadwiptec]

bill that sounds good. but how can I see to that where the end date is the last date of the month

for ex

load....

resident....where only the last date = oit should be dynamic based on the month

[Anonymous]

You could use the MonthEnd() function :

     MonthEnd(Today())

[#4]

You can check against Now() or Tpday() function in the script.

IF Floor(Now()) = Floor(MonethEnd(Now())) THEN

     AGGR_TABLE:

     LOAD

          FIELD1,

          FIELD2,

          FIELD3,

          EXPRESSION1,

          EXPRESSION2

     RESIDENT FactTable

     GROUP BY

          FIELD1,

          FIELD2,

          FIELD3

     ;

     STORE AGGR_TABLE into QVD_NAME.qvd (qvd) ;

ENDIF