Date field in dataset functions

Posted By: Zheka

Date field in dataset functions - 12/14/17 02:26

Hello,

1) upon parsing a file with dates for years from 2012 to 2017 ( date field in the format 3/12/2012, dataSaveCSV shows everything is processed correctly, except all years got changed to 2020.

Why would this happen?

2) dataSort()on the same dataset changes all dates arbitrarily to sequential days, starting from 1/1/2020 to 12/30/2020 (first record). While the original dates had been from 2012 to 2017 with 1 record per week (for Fridays).

Am I missing something?

Posted By: jcl

Re: Date field in dataset functions - 12/14/17 09:55

http://manual.zorro-project.com/format.htm

You can find many examples of dataParse in the included Convert scripts.
© 2024 lite-C Forums