Visokio website     Downloads     Video tutorials     KnowledgeBase  
Date/ week calculation: Date minus an integer - Visokio Forums
Date/ week calculation: Date minus an integer
  • craven99 August 24, 2016 7:40AM
    Hi,

    I have a week field - which was duplicated from a standard date field and works fine. But our payroll team work on a back week so they wish the filter to be the current displayed week minus 1 week. So Omniscope is correctly stating week 34 - but my team need it to show week 33. Can for the life of me figure out how to get the field to show this - am I missing something simple?
  • 1 Comment
  • craven99 August 24, 2016 8:30AM
    Knew it was something simple! FOund it
    DATEADD(FIELD, -1, "week")

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership