How do I reference a date value column in an if statement formula (e.g. if(date

Options
dominic_bardele
dominic_bardele Registered Posts: 5 ✭✭✭✭
Hello, I am trying to write a formula (if statement) that references a date column. I've tried many various combinations of referencing the date value with and without the val() command and with various formatting of the actual date column, but I cannot get my if statement to work. My goal is to write something like if(date_column<2018-01-01,"TRUEoutput","FALSEoutput"). Nothing shows up in the sample output or the actual output so I must be writing my expression wrong. Any ideas? My date format is shows as "MM/dd/yyyyT00:00:00.000Z".
Tagged:

Best Answer

  • Alex_Combessie
    Alex_Combessie Alpha Tester, Dataiker Alumni Posts: 539 ✭✭✭✭✭✭✭✭✭
    Answer ✓
    Options

    Hello,

    At the moment we do not support > or < operations in formulas for dates. Instead, you can use a formula like this:

    if(diff(date_column.asDate("MM/dd/yyyy"), '2018-01-01'.asDate('yyyy-MM-dd'), 'days') < 0, 1, 0)

    If your date column has the 'T' in its values, the format for the asDate() parameter will be "MM/dd/yyyy'T'HH:mm:ss.SSSZ

    Cheers,

    Alexandre

Answers

Setup Info
    Tags
      Help me…