Reinaldo,
There's an even better solution: GISDK has a function called
NextDate(), which returns a new date given an original date and an
offset in days. So, if you have your numeric dates stored in a field
called "numeric_date" you can get the conversion with a single line of
code:
textdate = NextDate("01/01/1900",
numeric_date)
And if you're looking to stay in the GUI, you can use the trick that
Kjartan reminded us of in message #4180 and just paste
NextDate("01/01/1900", numeric_date)
into a formula field.
Just one warning about this function: it doesn't accept negative
numbers (at least not in Mapt 5.0), so you can't convert dates before
1/1/1900.
Best,
Moshe
--- In [email protected],
Reinaldo Paul Pérez Machado
<rpmgis@...> wrote:
>
> /*Hi guys,
>
> Thank you very much Mlarue and Christine for the aid. Like the
previous
> problem regarding the perimeter, this was accomplished in a very
simple
> way. I have just exported the offending column (with the dates
depicted
> in the required way) together with an ID to CSV format. Next step
was to
> join data views and... Problem solved! No formulas, no formating.
I
> would like to share this.
>
> Cheers,
>
> Reinaldo*/
>
>
------------------------------------------------------------------------
>
> mklarue99 wrote:
> >
> >
> >
> >
> > --- In [email protected]
<mailto:Maptitude%40yahoogroups.com>,
> > Reinaldo Paul Pérez Machado rpmgis@ wrote:
> > >
> > > /*Hi,
> > >
> > > Does anybody knows how to convert 5 digit numbers from
Excel
> > spreadsheet
> > > (sequential days starting at 1/1/1900) into plain text
format?
> > >
> > > Thanks,
> > >
> > > Reinaldo
> > > */
> > >
> > Renaldo:
> > Do you wish to (or are you able to) add a column in excel
that will
> > contain the date in test form? If so, you can use the function
> > "=TEXT(B1,"00000")" (without the quotes) in a new column --
and note
> > that the "B1" should be changed to refer to the source column
(the
> > column with the date).
> >
> >
>
