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

Dividing (not formating) all the results by 1000
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.