Copy/ pasting dates

Discussion of bugs in GS-Base
Post Reply
martyn
Posts: 20
Joined: Thu Dec 29, 2011 5:14 pm

Copy/ pasting dates

Post by martyn »

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.
User avatar
citadel5
Posts: 228
Joined: Tue Apr 20, 2010 11:58 pm

Re: Copy/ pasting dates

Post by citadel5 »

Ad. 2)
Please select the "Save date/time serial numbers as date/time strings" option
in GS-Calc when exporting that text file to GS-Base.
If the date format in GS-Calc was not generic, use the "Edit > Convert > Text To Standard Date/Time Strings" command in GS-Base for that field.

GS-Base uses dates in the text form. A "date" field in GS-Base is a text field
containing date (or/and time) strings in the generic w3.org format (e.g. yyyy-mm-dd).
Of course, typically you apply to such a field one of the available date/time styles
to enter and display dates in a given (system or custom) format, nevertheless when
importing/saving/exporting the generic format is used.
GS-Calc can/convert use both forms.

Ad. 1)
Yes, it's a bug. Thanks for reporting it. This may occur if you copy those blocks
of dates in the table view within already existing records and the target field/column
is sorted. If this happens, the source block will be pasted correctly within any
sequence of records for which sorting didn't change their default "precedence"/order, then
pasting will restart for other records.

Please download the updated and corrected version.
martyn
Posts: 20
Joined: Thu Dec 29, 2011 5:14 pm

Re: Copy/ pasting dates

Post by martyn »

Thanks for a super fast reply.
Very helpful.
Happy New Year!
Martyn
Post Reply