date format conversion export to dbf

[Hutchinson, Pamela]

Hi

 

Can you help, I am using table / export to a .dbf file. All my dates which are in Date / time format are being converted to Text.  Is there a way to have them stay as a date format.

 

Thanks Pam

 

PAM HUTCHINSON
Asset Technical Assistant
City of Wanneroo

T   :   08 9405 5374
F   :   08 9705 5095 
E   :   pamela.h...@wanneroo.wa.gov.au

23 Dundebar Road, Wanneroo WA 6065
Locked Bag 1, Wanneroo WA 6946

wanneroo.wa.gov.au

 

 

  ________________________________  

Disclaimer: The material transmitted in this E-mail may contain confidential and/or privileged material and is intended only for the addressee. If you receive this in error, please notify the sender and destroy any copies of the material immediately. We believe this e-mail to be free of viruses but recommend that you confirm this before opening any attachments.

[Davidll]

Hi Pam,

I think this is to do with the fact that Microsoft discontinued
support for DBF files in 2007.

You can use older versions of excel or even try Open Office Calc to
open a dbf file and have the dates formatted as dates.

Another way is to export as txt and when opening the txt file in Excel
go through the import process to specify the date columns as Date YMD,
this will bring them in appropriately.

Cheers
David L

On Dec 6, 9:50 am, "Hutchinson, Pamela"

<Pamela.Hutchin...@wanneroo.wa.gov.au> wrote:
> Hi
>
> Can you help, I am using table / export to a .dbf file. All my dates which are in Date / time format are being converted to Text.  Is there a way to have them stay as a date format.
>
> Thanks Pam
>

> PAM HUTCHINSON
> Asset Technical Assistant
> City of Wanneroo
>
> T   :   08 9405 5374
> F   :   08 9705 5095

> E   :   pamela.hutchin...@wanneroo.wa.gov.au

>
> 23 Dundebar Road, Wanneroo WA 6065
> Locked Bag 1, Wanneroo WA 6946
>
> wanneroo.wa.gov.au
>
>   ________________________________
> Disclaimer: The material transmitted in this E-mail may contain confidential and/or privileged material and is intended only for the addressee. If you receive this in error, please notify the sender and destroy any copies of the material immediately. We believe this e-mail to be free of viruses but recommend that you confirm this before opening any attachments.
>

>  Picture (Device Independent Bitmap) 1.jpg
> 2KViewDownload

[Hutchinson, Pamela]

Thanks David

I will try the txt.
At the present I am coping the table converting to date and then exporting and this is working.
I have been told that we have to have all our "date" fields in "date/time" format for the interface with Intramaps, so the master layers have to stay in "date/time" format.

Thanks Pam

PAM HUTCHINSON
Asset Technical Assistant
City of Wanneroo

T : 08 9405 5374
F : 08 9705 5095

E : pamela.h...@wanneroo.wa.gov.au

23 Dundebar Road, Wanneroo WA 6065
Locked Bag 1, Wanneroo WA 6946

wanneroo.wa.gov.au

Hi Pam,

Cheers
David L

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

[Uffe Kousgaard]

Hi Pam,

 

DBF do not have a date/time field type, only a date field type. You will have to come up with some other way to handle the data in DBF.

 

Regards

Uffe Kousgaard

 

--

You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---