I am trying to calculate the number of working days between 2 dates, so it seems quite simple, but it does not work... I guess it comes from the format of my data, but I tried many things to make it working.
Here is my code. This is an expression I calculate in a chart
AMD_DATE is a timestamps, I guess it should work without the Date#() but it does not work. RCVDATE is a number which represents a date in the format YYYYMMDD. My date format is D/MM/YYYY, and the function Date#() is well working on other data.
edit: it seems that Date#(AMD_DATE) returns YYYY-MM-DD hh:mm:ss format while Date#(RCVDATE) returns YYYYMMDD format. I guess I need the same format for both, how can I do this?
Has anyone an idea of why it is not working?
Thank you for your answer