Copy/ pasting dates
Posted: Thu Dec 29, 2011 5:25 pm
1. GCalc with copy + past columns of dates ok within itself but messes up pasting into GBase- the 1st dat is ioften repeated twice + the last date omitted.
eg
12/08/2011
11/11/2011
20/09/2011
06/10/2010
13/05/2011
30/09/2011
09/02/2011
will paste as
12/08/2011
12/08/2011
11/11/2011
20/09/2011
06/10/2010
13/05/2011
30/09/2011
If pasing long columns of dates the flaw is compounded.
2. When importing dates the nummeric format will not change to a date format despite formating the cells with the style date function
eg
40884
40675
40896
40896
40896
cannot be formated to, say
11/11/2011
20/09/2011
06/10/2010
13/05/2011
30/09/2011
Hope this proves useful.
eg
12/08/2011
11/11/2011
20/09/2011
06/10/2010
13/05/2011
30/09/2011
09/02/2011
will paste as
12/08/2011
12/08/2011
11/11/2011
20/09/2011
06/10/2010
13/05/2011
30/09/2011
If pasing long columns of dates the flaw is compounded.
2. When importing dates the nummeric format will not change to a date format despite formating the cells with the style date function
eg
40884
40675
40896
40896
40896
cannot be formated to, say
11/11/2011
20/09/2011
06/10/2010
13/05/2011
30/09/2011
Hope this proves useful.