Blink

<a href="#h_003b889991">Formatting Requirements</a>

<a href="#h_ec3bcc2ad4">How to do this in Excel</a>

<a href="#h_05e2a4d2e9">Other helpful resources</a>

- <a href="#h_003b889991">Formatting Requirements</a>
- <a href="#h_ec3bcc2ad4">How to do this in Excel</a>
- <a href="#h_05e2a4d2e9">Other helpful resources</a>

The user's first day and last day fields in the bulk update template have specific requirements in order for the system to accept the update. They are optional fields but, should you choose to you them, they are expected to be filled out in the format <b>YYYY-MM-DD</b>. These cells should be in a <b>date </b>format: the upload may fail or register as an incomplete template if the cell and values aren't entered in the correct format.

Follow the <a href="https://helpdesk.joinblink.com/en/articles/6979726-bulk-updating-your-users#h_d386956f0d">bulk update flow</a> to obtain your import template

Scroll to the column with the header "first_day" and select the column 

Enter all dates following the year, month, day format: YYYY-MM-DD

1. If you're copying and pasting in data, be sure to select to use the source formatting. You can do this by clicking the Ctrl menu shown below and selecting "Match Destination Formatting (M)" 


1. Follow the <a href="https://helpdesk.joinblink.com/en/articles/6979726-bulk-updating-your-users#h_d386956f0d">bulk update flow</a> to obtain your import template
2. Scroll to the column with the header "first_day" and select the column 
3. Enter all dates following the year, month, day format: YYYY-MM-DD
   1. If you're copying and pasting in data, be sure to select to use the source formatting. You can do this by clicking the Ctrl menu shown below and selecting "Match Destination Formatting (M)" 


If you're looking for more helpful resources on bulk updating users and/or creating bulk imports, please check out the articles below:

<a href="https://helpdesk.joinblink.com/en/articles/6979726-bulk-updating-your-users#h_d386956f0d">Bulk updating your users</a>

<a href="https://helpdesk.joinblink.com/en/articles/6979809-import-multiple-users-at-once#h_28cb0ffce7">Import multiple users at once</a>

<a href="https://helpdesk.joinblink.com/en/articles/6979902-importing-your-users#h_e0f5808e9c">Importing your users</a>

- <a href="https://helpdesk.joinblink.com/en/articles/6979726-bulk-updating-your-users#h_d386956f0d">Bulk updating your users</a>
- <a href="https://helpdesk.joinblink.com/en/articles/6979809-import-multiple-users-at-once#h_28cb0ffce7">Import multiple users at once</a>
- <a href="https://helpdesk.joinblink.com/en/articles/6979902-importing-your-users#h_e0f5808e9c">Importing your users</a>

Formatting tips and guidance for entering start dates in the bulk update/import template