Project date fields

Here we explain the purpose of each date field in tiny+ for projects.

This information is most useful to advanced administrators and system-integrators.
Name
Field Type
Purpose
Access
Created Date
created_date
DateTime
The datetime the record was first created.
Read-only
Modified Date
modified_date
DateTime
The datetime the record was most recently updated.
Read-only
Start Year
year_start
Integer
An optional field which can hold the calendar year (eg 2019) that the project started.
Read/Write
Start Date
start_date
DateTime
An optional field that you can populate with the date the project began.
Read/Write
End Date
end_date
DateTime
An optional field that you can populate with the date the project concluded.
Read/Write
Close Date
close_date
DateTime
This field is autopopulated with the datetime stamp a project is marked as Won, Active, Lost or Cancelled. It can be manually overridden.
Read/Write
Completed Date
completed_date
DateTime
This field is autopopulated with the datetime stamp a project is marked as Completed. It can be manually overridden.
Read/Write
Expected Start Date
expected_start_date
Date
A user-entered date for when the project is expected to commence.
This field, combined with expected_duration and expected_finish_date are presented together in the user interface and are semi-automatically populated based on related values. 
Read/Write
Expected Duration
expected_duration
String (ISO 8601 Duration-only format)
A user provided period identifying the expected length of time this project will run for.
(eg. P4M for 4 months, P14D for 2 weeks, P40D for 40 days).
This is parsed input so the user just selects days/weeks/months and enters a number.
Read/Write
Expected Finish Date
expected_finish_date
Date
A user provided date for when the project is expected to conclude.
Read/Write
Proposal Received Date
proposal_received_date
Date
A user provided date for managing proposals. This tracks when a fee proposal is received.
Read/Write
Proposal Due Date
proposal_due_date
Date
A user provided date for managing proposals. This tracks when a fee proposal is due.
Read/Write

Using tiny+ - Previous

Advanced topics

Single Sign-On (Azure)

Last modified 3yr ago

Name	Field Type	Purpose	Access
Created Date `created_date`	DateTime	The datetime the record was first created.	Read-only
Modified Date `modified_date`	DateTime	The datetime the record was most recently updated.	Read-only
Start Year `year_start`	Integer	An optional field which can hold the calendar year (eg 2019) that the project started.	Read/Write
Start Date `start_date`	DateTime	An optional field that you can populate with the date the project began.	Read/Write
End Date `end_date`	DateTime	An optional field that you can populate with the date the project concluded.	Read/Write
Close Date `close_date`	DateTime	This field is autopopulated with the datetime stamp a project is marked as Won, Active, Lost or Cancelled. It can be manually overridden.	Read/Write
Completed Date `completed_date`	DateTime	This field is autopopulated with the datetime stamp a project is marked as Completed. It can be manually overridden.	Read/Write
Expected Start Date `expected_start_date`	Date	A user-entered date for when the project is expected to commence. This field, combined with `expected_duration` and `expected_finish_date` are presented together in the user interface and are semi-automatically populated based on related values.	Read/Write
Expected Duration `expected_duration`	String (ISO 8601 Duration-only format)	A user provided period identifying the expected length of time this project will run for. (eg. P4M for 4 months, P14D for 2 weeks, P40D for 40 days). This is parsed input so the user just selects days/weeks/months and enters a number.	Read/Write
Expected Finish Date `expected_finish_date`	Date	A user provided date for when the project is expected to conclude.	Read/Write
Proposal Received Date `proposal_received_date`	Date	A user provided date for managing proposals. This tracks when a fee proposal is received.	Read/Write
Proposal Due Date `proposal_due_date`	Date	A user provided date for managing proposals. This tracks when a fee proposal is due.	Read/Write