Skip to main content

I have a column called 'job requisition freeze date' and a column called 'total number of days frozen'. The 'job requisition freeze date' is formatted as a date. The 'total number of days frozen' is formatted as a whole number.

 

I am trying to take away the 'total number of days frozen' from the 'job requisition freeze date'. In my example:-

 

'job requisition freeze date' = 30/09/2021

'total number of days frozen' = 36

so the answer should be = 25/08/2021

 

Below is the formula I am using:-

DATEADD('day',-[Total Number of Days Frozen],[Job Requisition Unfreeze Date])

 

However, for some reason the answer is coming out as 29/09/2021?

 

Anybody any ideas how I can resolve this?

3 answers
  1. Aug 7, 2023, 1:55 PM

    Hi Guys,

     

    Thanks for your help. I have the answer now;-

     

    DATEADD('day',-{FIXED [Job Requisition ID] : SUM([Total Number of Days Frozen])},[Job Requisition Unfreeze Date])

     

    Obviously you wouldn't be able to get this without the .twbx file as the answer was dependent on the structure of the data.

     

    Thanks once again!👍

0/9000