Excel to CI - all date fields inherit value from first field
Please can anyone help on the following issue that I have …
I am attempting to build a new CI to load new assets, which I have achieved successfully.
The CI is based upon the Asset INTFC_FINPHY_SS, CI, and through testing, I have identified that I have to enter a date value multiple times in the following fields - Transaction Date, Accounting Date, In Service Date, Acquisition Date, Asset Custodian Eff Date and Location Effective Date.
Not sure what the correct terminology is, but is there any way that I can get the dates to default from the first date entered - what I mean to say is I enter a date of 01/11/2020 in the Transaction Date field and all other asset dates inherit the same value). Is this possible , and if so how ?