How to Do Trend By using String Field in servicenow Reports

[Community Alums]

Hi Team,

I have created a string field which has value of Date/Time. I do not want to convert the data type from String to Date/Time.  I want to use trend BY option in servicenow reporting

Can someone give some alternative how to do this without disturbing the dictionary?

[Uncle Rob]

"I want the benefits of a date time field without it being a date time"
The whole point of making date/time data types is so that they *behave* like date/times.  In this case, TREND only works on datetimes because the date/time field knows what it means when TREND says "week" "day" "year", etc.  A string is ONLY characters that can sort alphabetically.

What benefits are you getting by keeping it a string in the first place?