If you pull up the job in Job Set  Up and select "Status".  System tracks Start and completion date, the last cost update date.  You can also ask your accoutant/ Controller to let you know which projects have been closed out on the books per the WIP schedule.  Hope this helps.

There really isn't a Job Setup date in the database. What you might do is pull up an Inquiry of all the transactions for the Job (Job Cost --> Inquiry --> Entries --> All Entries) ,Condition it for the Job you're working with, insert a column for the "Date Stamp" field and then export the resulting Inquiry to Excel. If you sort the Excel file by Date - Oldest first, the first entry will be the first time the job had a transaction posted to it. Not exactly what you're looking for, but it should give you a pretty goodl idea.

If your database has a History Transaction file, you should try that first in the Inquiry, as it should include the oldest entries. If the inquiry comes up blank for the Job when you select History, try again but select the Crurent file.

Thanks for the reply.  What you say is true, but in my specific case, the jobs in question have no transactions so your suggestion doesnt help me specifcally.  I cannot tell if these are very, very old jobs with no transactions, or very,very new jobs with no transactions  (yes, I realize our job setup process probably needs work).

But I think you did answer me in telling me that there really isnt a job setup date in the database....bummer.  Thanks for the reply.

Thanks for the reply and the notes.  I am the accountant/controller.  :-)  We are unsure if these are very old jobs needing to be closed (zero transactions) or very new jobs (with zero transactions).   A job setup date would help solve that issue.

This is a great idea. I was assuming the start date hasn't been entered. If the users have been entering the dates, that would be the best solution. However, the system doesn't record the Start and End Dates and, in my experience, they are often left blank. The one date that is updated automatically by the system is the "Last Cost Update". This would be very helpful, but I have seen some databases with incorrect dates - if an AP invoice is entered wtih a date in 2029, for example, that date becomes the Last Cost Update date. It is only updated when an entry after that date is posted. 

Interesting. I'm not giving up yet. Have you checked the Date Stamp on the Job table? It should show the last date the Job was modified.

When you say "the date stamp" field, I am not sure what you are referring to.  The start and completion date fields that AnaC mentioned above are manually edited fields by users.  In my case, nothing as been manually entered.  I am looking for a system recorded field that tells me when the job was created.  (as you said below, that doesnt exsist.  

I also have ODBC connection to the JCM_Master_Job table and I am not seeing any data fields with populated data that resemble a "Date Modified".  Perhaps I am just overlooking it, but maybe not if it just doesnt exsist.

Sorry for not being clearer - I think I mentioned in my earlier post that the Date Stamp field is automoatically assigned by the system. This applies to transations as well as master files, such as the Job. Every time an update is made to the Job or an entry is posted to it, the date stamp is updated to the actual date of the change. It's not using the Transaction Date or Accounting Date, it's the date on your server.

You may want to consider adding a Job Custom field to track the date the Job was created going forward. As previously mentioned, there isn't a field that tracks this automatically on the Job. The Date Stamp on the JC Record will be updated any time anything is updated on that Job (even if you just go into Setup Jobs and change something and click Save.)  You could feasibly use the Estaimated and/or Revised Start Dates for this purpose as well, but those are there for another purpose so if you really want to be able to keep track of when the Job was added in Job Cost, create a custom field.  You can make it required but keep in mind that if you make it required you will need to populate it on all existing jobs as well, or Job Cost won't let you out of Setup Jobs until you do.

It also may help if you number your jobs beginning with the year (ex. 20-001, 20-002, etc.). We use the current year (20) and then incretment job numbers by 1, so 20-001 would be the first job of 2020.  Hope this helps.

There are multiple fields in the Job data table that can be useful along with JC Formulas that add the Job totals to the accumulated Job Extra totals to provide information that would lead to a conclusion for you. One field is the "Actual Start Date" which is populated with the date of the first transaction posted to a job.  You can also filter on the JTD Cost field, or if you use "Extras" you can use the equivalent JC Formula field that reflects the total of JTD Total and JC Extral Totals.  There are many other JTD fields, both in the Job table and in the JC Formula table, including JTD Billed, JTD Receivable Balance, etc.

Examine the Job fields from within Report Designer by doing to Tools > Available Fields, and select Job Master File. Select those fields and create a report in Report Designer (if you have it), or customize and inquiry and export it to Excel and do you manipulations there by adding fields together or filtering on data fields.

do these jobs have estimates?  if so you can see when the estimates were entered by going job cost, transactions, cost/estimate transactions.  go to the job number and you will see the estimate and date of estimate.

Excellent idea! If you want to change the format of your job to reflect this new coding method (xx-xxx) the Sage database team can update all your records with the new Job iD format. There's a modest fee for the work, but it's nice to know that it is an option!