What is the difference between TREND and RELATIVE in date field?

[DINESH CHINNAD1]

I understand something about TREND..

TREND is a DATEPART it contains (year,month,day,hour, minutes).

RELATIVE   is a REALTIVE it also contains (year,month,day,hour, minutes).

Exactly what is the meaning of relative?

Can anyone please let me know where we use these Trend and Relative?

Thanks in Advance,

Dinesh Chinnadurai  

[Mike Allen]

Looking at the results, it looks like trend is something like On Monday, or On Friday and returns all records in the table that fits that.   So you can say, give me a list of all incidents created on a Monday (any Monday), and that would be trend.

Relative gives you the ability to say give me all data related to a time period ago, and the data before or after it, etc.   So, relative would be asking for all incidents created in the past 15 hours, and would be a sliding 15 hours, so if you ran it at 3am, it would go from 12 pm - 3am and if you ran it at 12pm, it would give you 9pm - 12pm.

[DINESH CHINNAD1]

@ mike allen

Just i saw one more example about Relative

in Trend we have all the datepart (all days, all months, all weeks,all years, all hours)

but in relative we have only (days, minutes, quarters, month, year), here we ago, from now to get all

Am i right...

[Mike Allen]

Relative is all the gs.xxxAgo() script actions.   So, gs.minutesAgo(), gs.daysAgo(), gs.monthsAgo(),etc.