Login Page - Create Account

Support Board


Date/Time: Thu, 03 Jul 2025 13:19:37 +0000



Post From: Working in SC Spreadsheet with datetime strings from Trade Activity Log

[2024-01-31 01:59:11]
j4ytr4der_ - Posts: 947
Yep that'll get the job done. Ugly but functional.

=DATE(VALUE(MID(F3,0,4)),VALUE(MID(F3,5,2)),VALUE(MID(F3,8,2)))