EnviroInsite Forum

Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Can't control date format in boring log


Senior Member

Status: Offline
Posts: 271
Date:
Can't control date format in boring log
Permalink  
 


How do I get the Completion Date field to just show the date in my boring log rather than the date and 12:00:00 AM, which is the current default?



__________________


Senior Member

Status: Offline
Posts: 271
Date:
Permalink  
 

To get the completion date to appear in the format you want, you need to enter the data as a text string.

1. If you're storing your data in a spreadsheet, then open Excel and go to the cell with the date. Click on F2 to edit the cell and place a single apostrophe at the beginning of the date. Then close Excel and try plotting the boring log again.

2. Database (like MS Access) - Open the database file in MS Access. Then double-click on the Wells table to start editing the table. Next change the view type to Design View. Finally, in the design view window change the Data Type to Text. Close that window and save and exit from the database.

__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.



Create your own FREE Forum
Report Abuse
Powered by ActiveBoard