by Alanwestwood » Thu Apr 10, 2014 2:42 am
Actually, on further consideration, for me at least, its less a need for a datevalue function and more a need for HanDBase to accept more date and time formats at csv import.
At present, to set up a new database I simply import a sample csv then change the fields to more suitable types (because they are all imported as text). So I convert many fields to Date or Time or Integer or Float, for example. Then I delete the imported records and reimport them, and they then get pretty well accepted as entries of the correct type - so Dates are imported as dates and can be sorted, filtered, calculated.
But HanDBase doesn't convert a very common datetime format - YYYY-MM-SS or YYYY-MM-DD HH:MM:SS which is commonly used because of course its sortable even as text. It would be great if this format imported by csv to HanDBase fields would get converted to a Date.
In fact, at the moment HanDBase insists on DD/MM/YYYY, it won't even accept DD-MM-YYYY, and we get 01/01/2000 for 'wrong' (ie unaccepted) date formats on import. This might also solve Patricks problem if he used the same approach as me.
Regards, Alan.