Forum Discussion
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 ...
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.
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.