Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Setting a specific time

Topic Labels: Formulas
Solved
Jump to Solution
283 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

Currently, this is the formula in the column to make it display the date of the upcoming Wednesday, but the times are random. I want to make the times in this column to all be 7:00am. Is there anyway to do this?

IF(3-WEEKDAY({Submitted at})<=0,
DATEADD({Submitted at},3-(WEEKDAY({Submitted at}))+7,'days'),
DATEADD({Submitted at},3-(WEEKDAY({Submitted at})),'days'))

image

1 Solution

Accepted Solutions

Hi @Sophia - my guess is that the formula is just picking up the time of the Submitted at field. You can force the Send Date field to 7am - something like this:

DATETIME_PARSE(DATETIME_FORMAT({Send Date}, 'MM/DD/YYYY 07:00'))

This just formats the date with a hard-coded 7am start and DATETIME_PARSE around this forces it back to date object.

See Solution in Thread

1 Reply 1

Hi @Sophia - my guess is that the formula is just picking up the time of the Submitted at field. You can force the Send Date field to 7am - something like this:

DATETIME_PARSE(DATETIME_FORMAT({Send Date}, 'MM/DD/YYYY 07:00'))

This just formats the date with a hard-coded 7am start and DATETIME_PARSE around this forces it back to date object.