How to convert a serial number date format from a cube into a date format in App Engine

Ansa Leonard

Good Day

I have a custom workflow cube for which the output value is a date field but stored as a serial number (20260810 = 46244). I need to validate if this workflow date is due in 3 days and then send an email to the respective planner as a reminder. I have the code for the email but I'm battling to convert the stored date into a date field and then use the current system date plus 3 days as reference to compare if the stored date is due.

So, in the "foreach(OLAPCell cell in sourceArea)", the value of cell will be the serial date format. Did anyone so something like this before or can someone provide me with some guidance how to code this?

Regards

Ansa

Martin Reischl

Hi Ansa,

I wrote a small code snippet which will do the trick for you, with a date in the iDate variable:

    int iDate = 46244;

    DateTime dDate = CreateDateTime(1899,12,30,0,0,0);

    dDate = AddDays(dDate, iDate);

    NotifyInformation("Date is " + ToString(dDate));

I hope it helps.

Best Regards

Martin