hello
i have the following table which im trying to read in foxpro cause its a dbf file.
ID |
DATE |
TIME |
1234 |
2014-07-15 |
08:00:00 |
5693 |
2014-05-11 |
11:45:00 |
i need to get the latest time for the current date so i know which id belongs to it.
foxpro doesnt allow the getdate() function
how can i join the date and time so it looks like '2014-07-15 08:00:00' into one column so i can perform a datetime function on it?
thanks