Skip to Content
Former Member
May 24, 2007 at 07:46 PM

days between tow dates in layout



I have two date characteristics in a lead column ( date from and date to), I have a key figure ( KF1) that needs be a formula ( date to - date from ) in order to obtain the days between them.

This formula is a visualbasic code with sapafterdataput macro.

When I put the data in the dates format dd/mm/yyyy, with this format my formula ( date to - date from ) works fine. But when I save the field changes and it is not recognized like date and my formula fault showing #VALUE.

I need some solution, with fox formula I don't found how can I obtain days between two dates.

I would appreciate your help.