Date conversion from number format to date format

[Former Member]

Hi guru!

I am trying to convert a date from a "number format" to a "date format".

This example will clarify the issue:

I need to convert the date (with a FM) from 3664290 (number format) to 2007.06.30 (date format yyyy.mm.dd).

Please let me know which is the correct function I should use.

Thank you very much,

Vincenzo

[Former Member]

Vincenzo,

In the example you have provided, What does the number 3664290 represents? Depending on the system you use the number format used for date can be different. For instance, some systems use epoch date, basically it stores dates in number of seconds elapsed since 1/1/1900 00:00:00.

Based on the number format logic, you can either use something standard or come up with your own function module to convert.

-Saket