How to Do Trend By using String Field in servicenow Reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2024 07:33 AM - edited 12-09-2024 07:34 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2024 08:07 AM
"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?