SQLite unable to convert dates to JulianDay in Calculated Columns
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 ...