nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date function not working

Hi, I'm trying to convert Open date line item- text formatted in to Date using Date function but getting blank in Date Final line item, could you please help me where I'm doing wrong

Tags

Modeling

Calculation Functions

Accepted answers

Hi @swapnil_J

Date function has this syntax.

Put year first, then month and last is your Day.

Thanks,
Manjunath

All comments

Hi @swapnil_J

Date function has this syntax.

Put year first, then month and last is your Day.

Thanks,
Manjunath

Hi @ManjunathKN , thanks, I almost forgot Anaplan will convert it into my browser date setting

Quick Links

Can you help?

Unanswered questions

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…