Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Default time in a date field

Topic Labels: Dates & Timezones
1674 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Charles_DeRosa1
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m using airtable as a project management tool amongst other things in my business. It’d be really great to have the time in a date field default to 5:00PM (EOD) for every date entered instead of the current default which is the current time. Is there a way to do this other than using a formula as I’d really like to use the new timeline feature which doesn’t seem to support formulas.

Thanks for the help!

2 Replies 2

I just ran a quick test, and formulas work fine with the new timeline view. One critical point to remember about this new view is that the start and end fields need to have the same options in their settings (e.g. time vs no time, GMT vs not GMT). As long as they’re both configured the same way, it should work.

Re: the 5 pm default, are you saying that you’d like the ability to override that time in certain cases, or do you always want it 5 pm no matter what?

Sorry I know this is an old thread, but I am having this same issue and have not found a solution. I would like to be able to set it so that when someone enters date, the time in that field defaults to 5pm, but then someone can manually change it to something else if they want to. Currently, if you enter a date, the time defaults to midnight unless it's manually changed. Do you know how to do this?