FiveTech Support Forums

How do I put a date into a dbf if the date is in the format: 06-Apr-1960
I am reading info from a .txt file ... The Windows date format in both computers (the one that makes the .txt file and the system that reads the .txt file) would be set to the same format.

I also notice that when set to this format, my dates in my listbox are all messed up.
Ex: 08-Sep-69 (as seen in my datepicker field) shows as 08-009-969 (as seen in the listbox)

In Windows date settings, this format is listed as: Short Date: dd-MMM-yy

Ok, i sorted out the first issue.

I still have the problem of the date being messed up in the Listbox.

Any ideas?

Fivewin function uCharToVal( "06-Apr-1960", 'D' ) returns Date correctly. You may check and use this function to covert date strings into date variables.

As far as my limited knowledge goes we may not use 'MMM' in short date formats in windows.