This formula from the blog produces the result with at time: 9/30/19 12;00am
What part of the formula needs to change to eliminate the time?
DATETIME_PARSE(DATETIME_FORMAT({Period},‘MM/DD’)&"/"&YEAR(NOW()))
Thank You
Hello, my first post to this community. This formula was entered and accepted with no errors. The issue is the second IF (in this case {Tax Type}='Sales Tax) does not produce a result.
Here is the formula:
IF({Tax Type}=‘Bank Rec’,IF({Qtr}=1,‘1/31’,I...
Not sure if this is your issue but here is a link to a similar problem I had. It was suggested (and worked) to add AND.
Second "IF" in nested statement returning no result Formulas
Hello, my first post to this community. T...
Justin, it worked. I really appreciate not only the reply but the quick and concise explanation. The AND function allows for the comparison i was looking for. Also I am glad you mentioned about the single select field. i have been using the multiple ...
