08-23-2019, 10:26 PM
I think I have a problem I'll need to code around. I am porting an app that formerly worked with MySQL tables to LiveCloud.
This means dates are stored in the MySQL format YYYY-MM-DD: e.g., 2019-08-23.
Unless I'm mistaken, LiveCode's date format options don't include this format. So, I'm guessing (will test soon), none of the available CDB query operators will allow me, for example, to select for a date less than or equal to 2019-08-23.
I assume, per the documentation, that "<=" won't work because the data is non-numeric and that "date<=" won't work because the data will be seen as a non-dateitem.
True? Any workaround suggestions? I'd definitely prefer not to have to reformat hundreds of thousands of records that include dates and rewrite dozens of lines of code that assume the MySQL date format as their basis.
Thanks in advance.
This means dates are stored in the MySQL format YYYY-MM-DD: e.g., 2019-08-23.
Unless I'm mistaken, LiveCode's date format options don't include this format. So, I'm guessing (will test soon), none of the available CDB query operators will allow me, for example, to select for a date less than or equal to 2019-08-23.
I assume, per the documentation, that "<=" won't work because the data is non-numeric and that "date<=" won't work because the data will be seen as a non-dateitem.
True? Any workaround suggestions? I'd definitely prefer not to have to reformat hundreds of thousands of records that include dates and rewrite dozens of lines of code that assume the MySQL date format as their basis.
Thanks in advance.