Search results

How can I convert a Date/Time field into a Date field?

I have been running this query for several weeks with no issues. Today I am getting an error "Invalid Procedure Call". Does anyone know how to resolve this?

I created a macro to output a table as "txt" format, the results differ from using the "right'click export" method in that the macro txt is not delimited and the "export" method is . . . is there something special that needs to be done to get the same result as the "export" method?

How can I convert a number format into a short time format? For example 0.125 should equal 3am.

How do you convert text stored as 300 (which is 3 pm) into a time field?

I have a text, date field I need to convert to a date field. For example: 2/11/14 is stored at text: 21114. How can I convert the 21114 into 2/11/14?

I have an issue where the time is stored as a number (example 742 = 7:42AM, 1942 = 7;42PM). I need to convert this to time, from military to 12 hour so I can calculate the hours worked for an employee between their time clock punches. Thanks for any ideas you can give.

My name is Sherri Kilgore and I am new to this site. I am a Materials Manager by trade, but have been known to be a power user of MS Office Suite. Because I am not a professional programmer there are times I need some help. I appreciate any help anyone can offer with my issues. I look forward to...