Hello,
I am trying to pull records where last shipment date + service cycle code (356D, 30D, 60D, 90D,etc) = date range.
This difficulty is that the service cycle code is a text field, I think I need to pull the numbers out only from the cycle code and convert to value in order to add the number of days to the last service date….
Otherwise, it is a simple query… nl("rows","Service Contract Line",,"Last Service Date"+"365","StartDate..EndDate")
I would appreciate any suggestions. thx.
Yvonne
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
you can Change the Service cycle code like this (Service cycle code in $D5)
(maybe in Cell E$5) =REPLACE($D$5;LEN($D$5);1;"") => Result is 365 (from 365D), 60 (from 60D)….
then you can use that result to calculate a date
$f$5 =Last Service Date + $E$5 (01.01.2014 + 365 ) => 01.01.2015
then use the result for an "NP"datefilter with start date (last Service date/or shipment date/in a cell) and enddate ($f$5)
right direction for you?
regards
jetsetter
Please sign in to leave a comment.