topic Re: Input DateTime in datatable in AutoCAD Map 3D Forum

Input DateTime in datatable

t_machiels — Mon, 21 Nov 2016 10:36:21 GMT

Hi,

Using the 'Schema Editor' i created a schema for a shapefile. Among the data i want to collect is a date. So i used the 'DateTime' datatype for that field.

No problems there. Connecting to the shapefile and adding geometry work fine as well. Adding most of the data isn't a problem either.

The problem i get is when adding the date. When the "Date"-field is selected in the datatable i can only type in the time. The date i can add with de 'Datepicker' but when i confirm my input the datatable shows "1-1-0001 0:00:00" in the "Date"-field. Opening the 'Datepicker" again it shows the last selected date (27-03-2014).

To see what date actually got registered i used the expression builder (in the style editor) to list the dates. The date listed is "0027-03--34 00:00:00"

It appears the date got parsed wrong.

Does anyone have an idea on how to fix this?

Regards,

Tim

Re: Input DateTime in datatable

kajar — Tue, 22 Nov 2016 14:43:04 GMT

You can change date using properties palette, there you can input just date without time.

Using data table you can input date using datepicker.

Kajar

Re: Input DateTime in datatable

t_machiels — Mon, 28 Nov 2016 11:11:19 GMT

Hello Kajar,

Thanks for your suggestion. That works just fine.

It's still annoying it doesn't work in the datatable as it is supposed to.

I've been contacted by Autodesk Support but unfortunately they can't reproduce the situation.

regards,

Tim

Re: Input DateTime in datatable

kajar — Mon, 28 Nov 2016 14:19:20 GMT

Can't reproduce the situation, how its possible? For them it was possible to add or edit date and time without datepicker in data table, just cant believe it?

Re: Input DateTime in datatable

t_machiels — Mon, 28 Nov 2016 16:08:31 GMT

They used the datepicker but their input got applied to the field. When i use the datepicker the date doesn't get applied.

In the properties window i can see the value for date is set to "Null". When i change the date in the properties window it gets accpeted. It also changes in the datatable. But when i use the datepicker in the datatable to change the date again it gets reset to "null". That i can see in the properties window.

It's clear. My datepicker is broken. 😞

Regards,

Tim

Re: Input DateTime in datatable

t_machiels — Tue, 20 Dec 2016 12:45:53 GMT

Hello,

I'll give an update on this issue.

Autodesk support provided me with a solution. I'm not entirely happy with it but it works.

I had to change the date notation in my Windows 7 system in the "country and languag" section to "dd.MM.yyyy".

This fixed the problem but now everywhere dates show with this notation instead of "d-M-yyyy" which i generaly use.

The dashes appear to be the main issue.

The issue has been forwarded to the development team.

Thanks to autodesk support.

Regards,

Tim

Re: Input DateTime in datatable

Anonymous — Sat, 24 Dec 2016 08:01:26 GMT

Hello,

to avoid these problems with DateType I normally just save dates as a string.

Maintaining a specific format: yyyy-mm-dd, it is easy to order by date and to compare different dates.

Best regards, Jack

https://geomarker.wordpress.com/

Re: Input DateTime in datatable

Alfred.NESWADBA — Sat, 24 Dec 2016 13:23:18 GMT

Hi,

>> it is easy to order by date and to compare different dates.

I would prefer the string type too, especially because transferring datafields between different types of database systems or different regional settings are always a joker for a no-go.

But in some cases you need the type date, e.g. to query about time-frames like show me the records for the last 100 days 😉

- alfred -

Re: Input DateTime in datatable

t_machiels — Mon, 02 Jan 2017 12:41:43 GMT

Hey guys,

Thanks for the suggestion. I just might do that. I'm not sure if I really need the extra DATETIME functionality (at the cost of changing my system settings). I'll have to think about that. It will depend on what I want to do with the dates.

To me using the DATETIME datatype just appeared to be a clean way to handle data although now that only seems to be an illusion.

Regards,

Tim