A
Akshay Guleria
Guest
I believe this is actually a problem. Just consider the below example and see how the conversion of date behaves when the separator changes. Peter Judge - Do you know if someone can check the DATE function implementation and find why the results differ when the separator is "," Note: Code executed ABL Dojo Code DISP 'Separator is `,` =>'. DISPLAY INT(DATE(01,26,66)) STRING(DATE(01,26,66)) DATE(01,26,66) FORMAT "99/99/9999" SKIP. DISP 'Separator is `.` =>'. DISPLAY INT(DATE(01.26.66)) STRING(DATE(01.26.66)) DATE(01.26.66) FORMAT "99/99/9999" SKIP. DISP 'Separator is `/` =>'. DISPLAY INT(DATE(01/26/66)) STRING(DATE(01/26/66)) DATE(01/26/66) FORMAT "99/99/9999" SKIP. Result: Separator is `,` => 1,745,191 26/01/06 26/01/0066 Separator is `.` => 2,439,153 26/01/66 26/01/1966 Separator is `/` => 2,439,153 26/01/66 26/01/1966
Continue reading...
Continue reading...