Date function not working

Options
swapnil_J
edited November 2022 in Modeling

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

swapnil_J_0-1668791463366.png

swapnil_J_1-1668791563100.png

 

 

Best Answer

  • ManjunathKN
    edited November 2022 Answer ✓
    Options

    Hi @swapnil_J 

    Date function has this syntax. 

    ManjunathKN_0-1668792048378.png

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

    Thanks,
    Manjunath

Answers