Need HELP! In quote Editor data not sorted properly!

trash

Well-Known Member
#11
Also read this one (especially bold one) in case you have just YY instead of YYYY.

Hello,

Thank you very much for your e-mail.

You are using dd/mm/yy date format which is unreliable because in creates ambiguity in cases like 01/02/03. Windows does not now if you mean January 2nd, 2003 or maybe February 1st, 2003 or maybe 2001, February 3rd or other...

StrToDateTime uses Windows conversion functions and they generally depend on regional settings that your OS currently has. But it also always understands ISO format, i.e. YYYY-MM-DD. So it is preferable to use YYYY-MM-DD so no ambiguity exists.

So I would use:
dt_uk = "20"+yy + "-" + mm + "-" + dd;

instead

Best regards,
Tomasz Janeczko
amibroker.com
https://groups.yahoo.com/neo/groups/amibroker/conversations/messages/192013
 
#12
Do you wanna waste people's time? There are no years 2015 and 2007 in your uploaded file. Also seconds in your file are all at zero while in your pics they are not.

Anyway format to import your file is this one.



Stop wasting people's time.
@trash dude sorry for wasting your and all people's time!Thanks!
DUDE problem arise after importing this file, and about seconds it was previous tick data,imported to ami via RTDMAN and and other data showing zero seconds was imported one with CSV file.And after import it shows mixed data.
Anyways i have sorted out this problem myself and don't need your costly time.
I wanted genuine help and not intended to waste anyone time!
 

Similar threads