This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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 ...
