Calculated field to capture +/- 28 days from date

• faulknerwilliam2

  SSCrazy

  Points: 2299

  More actions

  September 18, 2015 at 1:24 am

  #321264

  Hello

  I need to create a calculated field that will give me 'yes' or 'no' if a date field is within +/- 28 days of another date field. So for example if a.date = 1/1/15 and b.date is 30/3/15 the calculated field will say 'no'; if the b.date was 10/1/15 it would say yes. Similarly, if the b.date was 1/11/14 it would say 'no'; if it was 10/12/14 it would say 'yes'.

  I appreciate I will need to write an IIF statement, probably nested, but am struggling with this, so any suggestions would be very welcome.

  Thanks

• pietlinden

  SSC Guru

  Points: 63428

  More actions

  September 18, 2015 at 1:45 am

  #1827653

  Sorry, didn't read very carefully...

  I think this will do what you want... or most of it.

  DECLARE @Date1 DATE = '10-Aug-2015',

  @Date2 DATE = '07-Sep-2015'

  ,@Diff INT

  SELECT @Diff = ABS(DATEDIFF(day,@Date1,@Date2));

  PRINT @Diff;

  the ABS() removes the sign...