Forum Discussion

tameismael's avatar
tameismael
Icon for Helper I rankHelper I
4 years ago
Solved

Custom Time Intelligence Function

Dear members,   I was trying to write a custom formula to implement the following expressions in many ways but I faced errors each time can you please help me out. The expression is : IF TODAY is >...
Custom Time Intelligence Function
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Like this?

     

    NumWeeks =
IF (
    TODAY () > DATE ( 2021, 9, 13 ),
    DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Like this?

 

NumWeeks =
IF (
    TODAY () > DATE ( 2021, 9, 13 ),
    DATEDIFF ( DATE ( 2021, 9, 13 ), TODAY (), DAY ) / 7
)
tameismael's avatar
tameismael
Icon for Helper I rankHelper I
4 years ago

Thanks indeed Alexis this is exactly what I was targeting I will try it out and hope it gives me the exact results.