Iterno + Date

nchamilton162 — Fri, 14 Apr 2023 17:59:10 GMT

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()
;

Re: Iterno + Date

Digvijay_Singh — Fri, 14 Apr 2023 19:41:29 GMT

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()

Re: Iterno + Date

Kushal_Chawda — Fri, 14 Apr 2023 20:33:46 GMT

@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()
;

topic Re: Iterno + Date in App Development

Iterno + Date

Re: Iterno + Date

Re: Iterno + Date