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.