In Excel, I can format a date as YYYY-MM-DD, however, when it is ingested into LiveCompare, it changes to (M)M/(D)D/YYYY. I've searched high and low in the Mr Excel sites of the world for how to get my Excel doc to force the YYYY-MM-DD or how to convert in SQLite from (M)M/(D)D/YYYY to YYYY-MM-DD, but everything comes up empty for me.
I was really close with doing a split of the string on / but some of the dates are 1/2/2019 for example and I dont get 2 chars for MM or DD. Long story longer, wondering if anyone knows a way to force LC to read in dates as YYYY-MM-DD from excel OR if anyone has a solution in SQLite to convert that date.
The reason I'm forced into using the YYYY-MM-DD is because all my other dates from ABAP systems, HANA, Java Netweaver are all in that format and I'm doing a Last Logon workflow so I need them to all be the same.
Thanks for reading,Chris