Search results

I got it to work. Thank you so much for all of your help. Here is what I ended up doing. I did this on both fields and then calculated the new fields. Works like a charm :) Start: CDate(Left([staffing_start_dt],19))

So PBaldy, On what you put ?cdate("2014-06-18 08:00:00") 6/18/2014 8:00:00 AM Would I replace what you have in quotes with my field name? I tried that, but I am getting a compile error.

No, that won't give me what I need. I need to calculate the number of hours between the 2 fields, start.date and end.date. But the field is stored as a text field and it's formatted like 2014-06-18 08:00:00.0000000.

I have a table from an outside database. The date/time is stored as a text field in the format of 2014-06-18 08:00:00.0000000. I have a start time and an end time field, both in that format. I need to calculate the time between, but it won't do it because it is a text field. I am trying to...