Change Field Type

Discuss the HanDBase for Windows Desktop program, conduits, and add-ons.

Change Field Type

Postby danmichsr » Sat Nov 04, 2017 10:43 am

I have over 4k entries and have a field called date but it's TXT.... Is there a way to get it into a DATE field?
danmichsr
 
Posts: 1
Joined: Sat Nov 04, 2017 10:39 am

Re: Change Field Type

Postby ddhsoftwareadmin » Sat Nov 04, 2017 1:23 pm

Hi,

There is a conversion from text to date but the format has to match exactly how it would look when it's converted. In other words, if your date format is set to MM/DD/YYYY and you have a date that says May 6th, 2017 it won't convert properly, it would have to read 05/06/2017. If you're using the windows desktop double check the conversion works before saving the file- it is possible this conversion code is only on the more up-to-date mobile devices only- my memory is fuzzy on the windows version!
ddhsoftwareadmin
Site Admin
 
Posts: 232
Joined: Tue Dec 09, 2008 2:13 pm


Return to HanDBase for Windows

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron