Expression for textbox, for datediff

• BKW

  Ten Centuries

  Points: 1350

  More actions

  February 10, 2009 at 12:50 pm

  #383909

  I need to show a textbox with a "Y" or "N" if the difference between 2 dates in my table is <= 1 day.

  Anyone help with this?

  Changinagain

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 10, 2009 at 1:03 pm

  #941574

  Fairly simple:

  IIF(DateDiff(DateInterval.Day, Date1, Date2) <= 1, "Y", "N")

  Date1 should be the earlier date.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• BKW

  Ten Centuries

  Points: 1350

  More actions

  February 10, 2009 at 1:33 pm

  #941610

  I will give it a try.

  Thanks, I needed that in a hurry, got bunches of detail reports to do in real short time and research time is soooo limited.

  Thanks again:D:D:D

  Changinagain