executor

Date function

Discussion created by executor on Dec 21, 2017
Latest reply on Dec 22, 2017 by beverly

I have a Field "DOC" containing the following information: 123AAA8881-000-2017.20.25

Ana another calculation field:

Date(

Month(Middle ( ${DOC} ; 21 ; 2 ));

Day(Middle ( ${DOC} ; 24 ; 2 ));

Year(Middle ( ${DOC} ; 16 ; 4)))

 

Calculation result is DATE. But return only "?"

 

I tried

Middle ( ${DOC} ; 24 ; 2 )

&"."&

Middle ( ${DOC} ; 21 ; 2 )

&"."&

Middle ( ${DOC} ; 16 ; 4 )

and it works. But when i export to excel. there is a problem with the field format.

Outcomes