Search results

Thanks, I've already created the query to get the capture/collar dates. I guess my question is how do I write the command that will give me all of the dates/times post capture in the second query? Will it be something like... >[the capture date field]?

Hi, I'm not sure how to explain this question clearly, but I'll do my best. I'm trying to query a table for dates and times greater than the dates and times specified in another table. I have multiple animals that were GPS-collared on different dates and times, but the collars were turned on...

Thanks, that worked great! Sorry for the long response time.

Yes, that is what I mean. The serial date is a number representing the number of days since 1900-Jan-0, plus a fractional portion of a 24 hour day: ddddd.tttttt We do a lot of work in excel with data and the serial date provides a unique value/time stamp associated with each datum...

Hi, I'm trying to add the date and time from two columns to create another column with a serial time. In other words I'm importing a large dataset and need to create another column that converts General Mountain Date and General Mountain Time (two separate columns) to a Serial Time. Is that...