0

Long Term Capital Gain

I am trying to tag a stock (equity) as to if it's "long term" (held more than a year) or short term. Using an "if/then/else" logic function, how do I configure the formula that looks at the transaction date and todays date and if it's greater than "365 days" then "Long" either "Short"?

1 reply

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    if number(today() - 'transaction date') > 365 * 1000 * 60 * 60 * 24 then
    "long"
    else
    "short"
    end

     

    Leo

Login to reply

Content aside

  • 5 yrs agoLast active
  • 1Replies
  • 1359Views