# Day of the year **URL:** \ **Category:** Ask for Help\ **Created:** [February 3, 2025, 6:19pm UTC](https://community.glideapps.com/t/day-of-the-year/79753 "2025-02-03T18:19:22Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![LAM\_DO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lam_do/32/79260_2.png) [@LAM\_DO](https://community.glideapps.com/u/LAM_DO)\ **Post date:** [February 3, 2025, 6:26pm UTC](https://community.glideapps.com/t/day-of-the-year/79753/2 "2025-02-03T18:26:08Z")
> [@date Guide on Dates & Times](https://community.glideapps.com/t/guide-on-dates-times/70381): > > The Date & Time column contains both a date and time value within one single value. Dates and times can therefore be tricky to understand and to work with. It helps to keep things simple to stay out of trouble. Here are a few tips: Writing dates Avoid writing dates manually. Use a picker instead. If done via import, be weary of the format of the date column in the source. Relations Anytime you create a relation with a date, convert the date to either a string (template column) or a number (… You might need it bookmarked. I’d use javascript column and get chatgpt to make it if anything beyound these --- _[View the full topic](https://community.glideapps.com/t/day-of-the-year/79753)._