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 > 9/13/2021, then count the # of days from 9/13/2021 to TODAY , then divide that number by 7 in order to get the # of weeks .

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
)

2 Replies

  • 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.