Visokio website     Downloads     Video tutorials     KnowledgeBase  
Comparing Date values: Filtering dates after 2014 - Visokio Forums
Comparing Date values: Filtering dates after 2014
  •     Phillipa August 3, 2016 5:54AM
    Hi all,

    I am totally new to dates in Omniscope and would like to know how to select dates post 2014.

    I have a field in date format dd.MM.yyyy HH:mm:ss and want to select records that are only after 2014.

    I know it is not rocket science but as a beginner I need some help.

    Thanks.
    Phillipa
  • 3 Comments
  •     Phillipa August 3, 2016 6:07AM
    Hi again,

    I think I have got it with the formula:

    IF([Start]>DATE(2013,12,31), 1, "")

    It seems to work, but if there is a more elegant solution, I would be glad of any tips or a link to working with dates.

    Thanks
    Phillipa
  •     paola August 3, 2016 6:21AM
    Hi Phillipa,

    You could try:
    IF(
    [Date]>TEXTTODATE("31/12/2013")
    ,
    "AFTER",
    null)
  • Robinp September 20, 2016 10:41AM
    Create a record filter and filter the date field with > than 01/01/2014

Welcome!

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

Sign In Apply for Membership