1 Reply Latest reply on Nov 24, 2016 1:17 PM by Norbert Maijoor

    dateadd

    wiem bekir

      hello everyone,

       

      I need to add the condition bellow to my date field :

       

      planned start  date between ( today  18h  et today+1 à 18h)

       

      Planned periode is today +1

       

      I am doing like that :

      NOW()<=[Planned Start] and

      [Planned Start] <=  DATEADD('hour',[Planned periode],NOW())

       

      is my condition true?

       

      thanks