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 )
the ¶ seems to not work in windows. Is there a better solution to achieve this?