Trying to do a datediff using two dates via API. Using the JulianDay calculation recommended by KS formulas. When doing so it returns a NULL. After investigating, JulianDay requires date as YYYY-MM-DD but the output of KS Date is MM/DD/YYYY. I am sure some level of SQL conding can do the conversion but the idea is to make this easier on the programmer, not harder.
I would like to see an example of this being done. It is a customer need and closing out an issue without approproate documentation is cheating the system. I worked for over 8 hours trying to make this work and involved several resources who all struck out. Awaiting your documentation.
This can be done. Has to be a documentation issue.