Employee Start Date

[Joe6]

Hi all!

I’m creating an employee roster, and wanting to list the start date of each employee to demonstrate longevity. I’m using custom fields to create this view/dataset.

However, I can’t get the dates to sort correctly. For instance, dates from 2017 are showing up after 2021.

Any insights on how to format the date in the custom field?

Thanks!

[Phil_Seeman]

Hi @Joe6,

See this forum post:

Sort by date... when there is no date field

Here is the trick of the day! Custom fields of type Date don’t exist yet, so usually people use a text field to store some date on a task (that is not the due date). If you want to be able to sort the task list based on that field, make sure to input dates in YYYY-MM-DD format. That way, an alphabetical sort will actually be a chronological order! Pretty cool right?

[Joe6]

Very helpful! Thank you!