How to Do Trend By using String Field in servicenow Reports

Community Alums
Not applicable

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?

 

1 REPLY 1

Uncle Rob
Kilo Patron

"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?