I have two strings which are times in "mm:ss" format.
I want to put these into a tables Date/Time field, also formatted "mm:ss"
But I'm getting a result of 12:00 instead of the mm and ss.
Should I change the table to a text field, solving the problem, or convert the strings into a time-compatible value ? If the latter is there a built in function for this ? Thanks.
I want to put these into a tables Date/Time field, also formatted "mm:ss"
But I'm getting a result of 12:00 instead of the mm and ss.
Should I change the table to a text field, solving the problem, or convert the strings into a time-compatible value ? If the latter is there a built in function for this ? Thanks.