Compare data between every friday and friday-30

[qlik99]

Hello,

I need to do comparaison between data of two dates (today and today -30) the problem is i receive only every friday a new file 

so if i will compare data of 17 September (the next excel file that i will receive ) it will be with 17 August (is not friday )... the QVD will fined 0 data in this date (he needs to compare it with Friday 13 August ) 

what i should do  ? 

thanks 

[Andre_Sostizzo · Accepted solution]

@qlik99, perhaps you can use the weekday() function to obtain the comparison you're looking for. 

https://help.qlik.com/en-US/sense/August2021/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTimeF...