Login Page - Create Account

Support Board


Date/Time: Mon, 25 Nov 2024 23:45:48 +0000



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

[2024-01-31 01:59:11]
j4ytr4der_ - Posts: 938
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)))