check if an expire date is within 18 months from now
Is this expression supposed to work? SO that the count of such "matches" can be aggregated in an insight to report on:case( (addMonths( $currentDate, 18 ) > WPR_test.Lease.Expire_Date), 1, 0)
Forum Posts
Data Source name or annotation to as a mnemonic especially multisource table
It would be very convenient to tag each data source with some name to serve as a hint for multi source tables. Otherwise ine is forced to inspect each datasource's method ie sql or code.
How to Disable Timezone Conversion for Date/Datetime Columns in Incorta?
We are running into an issue where date or datetime values are shifting by one day after being loaded into Incorta. Our source system does not include any timezone information in these fields, but Incorta still seems to apply a timezone conversion so...
Incremental Load query
Hello Community,We have a schema that is currently scheduled with a full load, and I would like to switch to incremental load for specific tables.These tables have a timestamp column (for example: creation_date) that should be used for incremental lo...
Session Variable forCurrent and Past two years
Hi,Period_Name like 08-25,09-25 .i want to Create a formula column Year from Period name and store Current year and past two years in that year column like below . Next year dynamically change the values to 2024,2025 and 2026. Please let me know how ...
