Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

How to modify this formula so the record lands on the right recurring date?

Topic Labels: formula formulae Formulas
46 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all,

The problem I'm seeing is when I use the formula below, the recurring date shows up properly in the current year, but one day to early.

DATETIME_PARSE(DATETIME_FORMAT({Recurring date},'MM/DD')&"/"&YEAR(NOW()))

This 3 minute video I made shows the problem:

https://www.loom.com/share/913091fb457b424b9836b6369c75bb10 

I realize the problem is likely caused by the Kamillionaire calendar block not considering that 12am (midnight) is really the current day vs. the day before. So my work around I'm hoping for is to modify the formula to show a time after 12am, like for example 6am. 

Kamillionaire site:

https://kamillionaireapps.com/ 

Thanks in advance for any suggestions,

Kelly

 

 

0 Replies 0