Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Build a valid date with DATE function (dd.mm.yy)

Dear all, I have some issues with building a valid date from this source: I have tried: DATO = DATE(TRLO[TRL_DAG], TRLO[TRL_DMND], TRLO[TRL_AAR])   I guess the formula fails because of ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    30 in the TRLO[TRL_DAG] stands for 2030, right?

    Adding two digits to 2000 turns it into a four-digit year.

     

    DATO = DATE(2000+TRLO[TRL_DAG], TRLO[TRL_DMND], TRLO[TRL_AAR])

     

    Then you can change the format you want.

     

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you very much.

I tried: 

DATO = FORMAT(DATE(TRLO[TRL_DAAR], TRLO[TRL_DMND], TRLO[TRL_DAG]), "yy.mm.dd")

and this one too:
 
DATO = FORMAT(DATE(TRLO[TRL_DAAR], TRLO[TRL_DMND], TRLO[TRL_DAG]), "dd.mm.yy")

I still get error message (in english like this): One argument in function DATE has wrong data type, or the result is too big or too small.

Best regards
Kenneth Pedersen
Tahreem24's avatar
Tahreem24
Super User
4 years ago

Anonymous Make sure all Year, Month, and Day columns are of type interer or whole number. They should not be a text column.