Requirement on Set analysis

[#1]

hi

i need to display data like:

1)Last 5 years data

2)last 5 months data

3)last 5weeks data

4)last 5 days data

5)Last 5 hours

my date fields is: OrderDate

Thanks

[sunny_talwar]

May be like this:

1) {<OrderDate = {"$(='>=' & Date(AddYears(Max(OrderDate), -5), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

2) {<OrderDate = {"$(='>=' & Date(AddMonths(Max(OrderDate), -5), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

3) {<OrderDate = {"$(='>=' & Date(Max(OrderDate) - 35), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

4) {<OrderDate = {"$(='>=' & Date(Max(OrderDate) - 5), 'DateFieldFormatHere') & '<=' & Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}

5) Is OrderDate a timestamp? If not, then I am not sure how this can be calculated

[#3]

yes it is a time stamp based

[sunny_talwar]

Then try this:

1) {<OrderDate = {"$(='>=' & Date(DayStart(AddYears(Max(OrderDate), -5)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

2) {<OrderDate = {"$(='>=' & Date(DayStart(AddMonths(Max(OrderDate), -5)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

3) {<OrderDate = {"$(='>=' & Date(DayStart(Max(OrderDate) - 35)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

4) {<OrderDate = {"$(='>=' & Date(DayStart(Max(OrderDate) - 5)), 'DateFieldFormatHere') & '<=' &Date(DayEnd(Max(OrderDate)), 'DateFieldFormatHere'))"}>}

5) {<OrderDate = {"$(='>=' & Date(Max(OrderDate) - 5/24), 'DateFieldFormatHere') & '<=' &Date(Max(OrderDate), 'DateFieldFormatHere'))"}>}