Good day all,
I have an Access database app that is somewhat of a task tracker. There is now a need to track the task start date/time and the end date/time for the eventual purpose of showing how long the task took to complete.
[RecStartDate] is the date the record was created and signifies the task start date/time.
[Date Closed] is the date/time that the record/task is completed.
Ultimately, I'm seeking a method to run a query or report that would show the length of time in days, hours, and minutes for the retrieved records.
Before we get into this, I would like to consider the best methods for doing so. Would it be better to split date and time into two fields or is better that they stay in one? Would it be good to have a date picker so they can hit "Today" to capture current date and time or, since all they need is the current date/time, would it be better to have a button that inserts the date/time instead of a date picker?
Currently, [RecStartDate] is capturing the date and time in one field. This Access app is repurposed and it has a query that makes reference to the [RecStartDate]. When it was built, the date format was Short and didn't contain Time. I haven't tested the query yet but my hunch is that since I changed it to include the Time, there may be a problem with the query if the data in the field now contains the Time.
Secondarily, the [Date Closed] field has been problematic. I have set the property of the field to General Date. I can't get the field to record the date and time, only date. If I force it to Date() Time(), it will place the date and time in the field but it will do it on record creation and not when a user chooses. I need the user to either hit "Today" on a date picker or hit a button that enters the date and time into the field. This all is under the assumption that I should have both date and time together. Please correct me if it would be better to separate date and time.
I haven't gotten past this issue yet so I haven't begun attempting to build a query or report that will yield the needed results. I will definitely need help in that area as well.
Many thanks in advance.
I have an Access database app that is somewhat of a task tracker. There is now a need to track the task start date/time and the end date/time for the eventual purpose of showing how long the task took to complete.
[RecStartDate] is the date the record was created and signifies the task start date/time.
[Date Closed] is the date/time that the record/task is completed.
Ultimately, I'm seeking a method to run a query or report that would show the length of time in days, hours, and minutes for the retrieved records.
Before we get into this, I would like to consider the best methods for doing so. Would it be better to split date and time into two fields or is better that they stay in one? Would it be good to have a date picker so they can hit "Today" to capture current date and time or, since all they need is the current date/time, would it be better to have a button that inserts the date/time instead of a date picker?
Currently, [RecStartDate] is capturing the date and time in one field. This Access app is repurposed and it has a query that makes reference to the [RecStartDate]. When it was built, the date format was Short and didn't contain Time. I haven't tested the query yet but my hunch is that since I changed it to include the Time, there may be a problem with the query if the data in the field now contains the Time.
Secondarily, the [Date Closed] field has been problematic. I have set the property of the field to General Date. I can't get the field to record the date and time, only date. If I force it to Date() Time(), it will place the date and time in the field but it will do it on record creation and not when a user chooses. I need the user to either hit "Today" on a date picker or hit a button that enters the date and time into the field. This all is under the assumption that I should have both date and time together. Please correct me if it would be better to separate date and time.
I haven't gotten past this issue yet so I haven't begun attempting to build a query or report that will yield the needed results. I will definitely need help in that area as well.
Many thanks in advance.