Difference Between Dates in Weeks from Different Tables

[Anonymous]

I need to determine the amount of weeks and days between two dates that come from two different tables in the load script. They have both already been loaded in different tabs from different tables, and I need to subtract one date from the other and express the difference in weeks and days (Ex: 17.3 weeks).

[#2 · Accepted solution]

Hey Bradley,

If you want to do this on the back-end you need to have both date fields in same table.Then

(Date1-Date2)/7 as WeekField

If you want to do it on the front end then the same formula in the expression but just make sure there is only one value for the dimensions.

Thanks

AJ