Example of a Date field populated in a UDF - stores as string field within SARA's database, will not sort properly as a date, only sorts as string:
Example:
-
09/01/2019
-
09/08/2018
Sorting of first characters (09) and not year
Need to change string for year in front using Substring:
-
20180901
-
20190901
Formula used:
Concat(Substring([LineUDF1],6 ,4 ),Substring([LineUDF1],0 ,2 ),Substring([LineUDF1],3,2 ))
NOTE: Substring(String, StartPosition, Length) function, the StartPosition is the position before the string you want and then the length starts on next position