Skip to main content

Hi team,



I’m hoping for some help. I am trying to work out the number of weeks between 2 dates. It keeps returning the results Nan and I have no idea what I am doing wrong. Here is the formula I am using.



I want to know how many weeks between “Cancel Date” and “Sale Date”. If anyone could give some input or advise it would be massively appreciated. Thanks



DATETIME_DIFF(


{Cancel Date},


{Sale Date (from Sales)},


‘weeks’


)

Hey Peta, hmm that looks right. Could you provide a screenshot of the relevant tables / fields so that I could troubleshoot it perhaps?



In the meantime, I’ve set something up here for you that you can use to compare against your own base






Thanks so much for your help Adam. Here are 2 screen shots





Thanks so much for your help Adam. Here are 2 screen shots






Hey Peta, it looks like the Cancel Date field is a Single Line Text field; could you try changing it into a Date field?

OMG you are my hero!!! It works!!! thank you so much!!! I really really appreciate your help. Thank you!

@Adam_TheTimeSavingCo Hi Adam, could you also check my formula? I’m having the same problem as @Peta_Howlett but both fields, in my case, are already in Date format.






@Adam_TheTimeSavingCo Hi Adam, could you also check my formula? I’m having the same problem as @Peta_Howlett but both fields, in my case, are already in Date format.







Hi Anita, your problem’s probably to do with the formatting of the Duration field I reckon





Try setting it to Integer instead of Duration

Thanks so much for your help. It worked!

Reply


Terms & Conditions