Clear a date formatted list property.

SofianeLz · 2025-03-25T17:49:18+00:00

There was an error rendering this rich post.

Hello everyone.

My case is simple : For a specific client need, I have a list with date property. Each time a date is input in the module, a process is run to "save" the input in the lists properties.

Some of these properties are date formatted line items.

When the client input a date and save it, the import sends the date from the module to the list property. But when he clear it in the module and then save, the line item "Date" of the list doesn't move.

I tried to add another process that specifically target this property with a "BLANK" date, but it doesn't work.

Anyone has an idea ? Is it a specificity of the date type ?

Thanks

Accepted answers

All comments

Dikshant

Do not load anything to list property, as it does not come under best practice; unless there is a reason to do so, then it must be fine.
In order to solve this, load the date in text format into the list property and then convert it into date format. Refer to screenshots below to understand more:

Module:

Formula to convert date to text in consistent format: IF ISBLANK(Date) THEN BLANK ELSE TEXT(YEAR(Date)) & "-" & RIGHT("0" & TEXT(MONTH(Date)), 2) & "-" & RIGHT("0" & TEXT(DAY(Date)), 2)

In the list property, create a property to load the date, and write the formula in the original date line item.

Update the import action to import into a text-formatted date line item.

rob_marshall

@SofianeLz

And especially don't have dates or transactional data in lists or list properties. Check out this document which explains why.

Link

seymatas1

Hi @SofianeLz,

This text-to-number-to-date formula will make a big impact on the model performance if your list is large.

If using list properties is your only option, write the formula in a line item and refer to that line item in the property.

I assume you are working on a previously built model; don't use list properties in a newly built model except for display names for numbered lists

Hope this helps,

Seyma 🌷🙂

devrathahuja

@SofianeLz - You can create another line item in a module with that list which "stores" this date instead of the property & then the property can refer to the line item.

So every time a user runs an action you'd import the date to a line item in a module & the list property would fetch it from this line item instead of a direct import to the property.

In this case when a date updates to blank, the date also clears in the module & thereby in the list property.

It is strange that the date does not clear when stored as a property in a list.

This would save you all the extra performance required in conversion of date from text & vice-versa.

However, yes avoid list properties to begin with unless an absolute must.

Hope this helps :)

SofianeLz

Thank you all @devrathahuja, @seymatas1 , @rob_marshall and @Dikshant .
The text conversion solution was the most suitable for me, thanks again.

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled