Returning the Date of when a contract starts
I have contracts with revenue and expenses by dates (differing start and end dates) in a module (Start date ="1", the second period ="2", so on until it ends of reached end of time periods). I'm building a dashboard which reports the start and end date of each contract, and then allows a user to input a revised start/end date to push it out or shorten it.
I'm struggling with returning the date of contract start and the contract end from that module for a quick reference of the end-user. I'm working into an approach of: Contracts.(Time Period)[LOOKUP: ContractStarts.FirstPeriod] (Where first period is "1"). However, I can't seem to return the date in my dashboard module and my Anaplan searches return me to the same two articles.
Unfortunately, all my searches keep returning me to the same Anapedia Formula instruction and one other thread which is vague.