Page 1 of 1

Excel dates

Posted: Wed Dec 14, 2022 10:58 am
by oblivion
Does GS-Base have a function to convert serial dates (as found in .XLS date fields after import) to usable date fields?

I expected the date() function to work, but it doesn't seem to, and I can't find anything else that can handle them...

Re: Excel dates

Posted: Wed Dec 14, 2022 2:22 pm
by citadel5
It's the "Edit > Convert Field Data > Serial Date Number to Standard Date Time String" menu command. (You may also need to change the field type from Number to Text.)

The date() function uses three parameters (year, month, day), not one. In general, this conversion can be automatic provided that the used predefined date format pattern in the Excel file will match one of the predefined date patterns in GS-Base.

Re: Excel dates

Posted: Wed Dec 14, 2022 4:37 pm
by oblivion
So much easier than what I was trying! Thanks!