I am trying to create a macro to output the start date of the bucket.
I imported the standard macro from book 9AEXAMPLES view macro BUCKET_BDATE(): Bucket Start Date and changed the row "Row: Production (Planned) ( Frm INITIAL ) " to a existing row in the view. I still have the datasource as "row attributes". But the output popup gives a big (garbage value??) 7.3344800000000000E+05 instead of some 10132008.
Am I doing any mistake here?
Mark Percox replied
You are getting the correct result; let me explain.
The function BUCKET_BDATE() returns the date expressed in whole numbers with reference to the date 01.01.0001.
So the number in your example the number returned represents the date 733448 days after 01.01.0001, which by my reckoning is 18/04/2011 (hopefully you recognise this date as the desired result).
It can be confusing if you try to check in XL, as XL uses 01.01.1900 as its reference date. However, if you take the number returned from the macro and subtract 692797 from it, you can 'date format' the result to see the date being represented.
Hope this helps, M