Aug 29, 2021 02:36 AM
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'))
Solved! Go to Solution.
Aug 29, 2021 03:03 AM
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.
Aug 29, 2021 03:03 AM
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.