On 14/07/2023 16:34, Bob Sneidar via use-livecode wrote:
CASE "sql date"
put item 1 of theDate & "-" & \
format("%02d",item 2 of theDate) & "-" & \
format("%02d",item 3 of theDate) into theDate
break
Why not just
put format("%s-%02d-%02d", item 1 of theDate, item 2 of theDate), \
item 3 of theDate) into theDate
Alex.
btw - you forgot the if/switch check for
"if in the USA" vs "if in the UK" :-) :-)
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
