Help

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

Topic Labels: formula formulae Formulas
476 0
cancel
Showing results for 
Search instead for 
Did you mean: 
KellyFidei
4 - Data Explorer
4 - Data Explorer

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