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
-
if number(today() - 'transaction date') > 365 * 1000 * 60 * 60 * 24 then
"long"
else
"short"
endLeo
Content aside
- 6 yrs agoLast active
- 1Replies
- 1361Views