AnsweredAssumed Answered

Mac end of line in script not working in windows

Question asked by paulkana on Jul 11, 2018
Latest reply on Jul 12, 2018 by fmpdude

Hello, I have this auto enter calc to calculate LOT numbers, it takes a date dd/mm/yyyy and transforms it to yymmdd

Code production &"-" &

Let ( [

adj =Substitute ( Date de production ; "/" ; ¶ ) ;

day = GetValue ( adj ; 1 ) ;

month = GetValue ( adj ; 2 ) ;

year = GetValue ( adj ; 3 )

];

Right(year;2)&month&day

)

 

the ¶ seems to not work in windows. Is there a better solution to achieve this?

Outcomes