Lookup date in a module

Hello,

Learning anaplan and am looking for options to do below without using list for lookup in the module . Not sure if there is a simple calculation within module that will help me implement below

In the module today we have Status Date and Completion as line items. If we have to populate new line item ( Start date & End date) on rows with 'Done' as completion , how can I do that. To populate start date I need to look up a different row in the module to get status date, wondering how I can do this with look up in a module.

Comments

ArunManickam

Hello @reachraj

It is not clear what is your question.

Assuming you wanted to calculate status based on the dates provided and today's date, You can calculate the status based on the dates, the status will be a list formatted line item and you can define the rules for the status list in a seperate system module. You need to maintain today's date in a system module as well.

Thanks

Arun

einas.ibrahim

Hi @reachraj

As of now, Anaplan doesn't have a function that returns today's date.
I am not sure the design of your module is the most optimum. Consider having 2 modules dimensioned by the same list (say Project ID), One will hold The project properties - static values- such as Name, Start Date and End Date and the other to hold the multiple statuses of the project (project ID, Date, Status).
Looking up a line item from the same module is the same as reading from a different module, you just don't need to provide another module name before the name of the line item you are referencing. LineItem[LOOKUP: LOOKUP Value), but I don't think it's needed with a thought out design.

Quick Links

Recent release news

October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…