Format for creating condition on date

[Former Member]

Hi,

I have a calender year day as my key figure. I want to create a condition on it. What format should I use to enter the date?

Please let me know if there is any special format followed for creating condition on calender year/day or calender year/month.

Thankyou,

-Sini

[Former Member]

I have the same problem. I have done some digging and found that the internal representation of the date key figure is some serial number (e.g. 732568) which I suspect is the number of days since the beginning of time (01/01/0000). When you enter this number into the condition it works.

The problem now is that no-one knows what should that number should be. Does anyone know how this "date serial" works or whether there is a function to convert a normal date to this format.

Thanks

[Former Member]

The format is YYYYMMDD --> 20061018 is today.

Hope it helps.

Regards

[Former Member]

Hi Paolo,

I entered the values in the format "YYYYMMDD" (20060120)and it takes the values in the following form "20,060,120". And it did not give me the correct result.

Please let me know if there is any other way to do.

I am on SP 8/ FEP 902/SAP GUI 640 patch 21

Thankyou,

-Sini