Skip to main content

Report Manager - Using Substring Function (Date String for sorting)

Updated

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