Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
I'm attempting to build a date span. I have a contract effective date and a contract expiration date. I'm attempting to generate dates between those two dates. I'm loading an excel file in and I'm formatting the dates in Qlik using the following syntax (see date(floor ) below. Currently my rate_contract_expiration_date is 03/31/2025. If I run the Load script below using that date it does not generate my span dates. If I change the 3/31/2025 to 3/31/2023 it works fine. Is there some type of issue with the date being too far into the future? I don't get an error, it just doesn't load my table with the date spans. Here is the info for the rate_contract_expiration_date field .
This is part of a tmp table I load and then I build try to build the date span.
,DATE(FLOOR(EFFECTIVE_DATE)) as rate_contract_eff_date
,DATE(FLOOR(EXPIRATION_DATE)) as rate_contract_expiration_date
Here is my final load script
Rates:
Load
*
,Date(rate_contract_eff_date+IterNo()-1) as rate_master_date
Resident tmp_rates2
While rate_contract_eff_date + IterNo()-1<=rate_contract_expiration_date
and Date(rate_contract_expiration_date + IterNo()-1)<=Today()
;
I think problem is here, it should be 'OR', not sure though.. -
While rate_contract_eff_date + IterNo()-1<=rate_contract_expiration_date
and Date(rate_contract_expiration_date + IterNo()-1)<=Today()
@nchamilton162 try below
Rates:
Load
*
,Date(rate_contract_eff_date+IterNo()-1) as rate_master_date
Resident tmp_rates2
While rate_contract_eff_date + IterNo()-1<=rate_contract_expiration_date
and rate_contract_eff_date + IterNo()-1<=Today()
;