Populate New Formula Output Field if date equals to today's date

I have multiple fields in a file such as product description, product type, price, effective price date, end price date, and currency.

However, I need to pull only product type, price and effective price date ONLY if the effective date matches today's date. I used the following formulas below but keep getting

'Parse Error at char(24): Malformed If Statement" error

Output Field: Type: Expression

ProductType String IF([Start Date]=[DateTimeNow(%Y%m%d)],[Product Value],"")

ProductPrice String IF([Start Date]=[DateTimeNow(%Y%m%d)],[Price],"")

ProductDate Date IF([Start Date]=[DateTimeNow(%Y%m%d)],[Start Date],"")

Error Message

Parse

Date Time

Expression

Accepted answers

NicoleJohnson

If you are using an IF statement with commas instead of the words "then" & "else", you need to use IIF (two letter I's)... so:

IIF([Start Date]=[DateTimeNow(%Y%m%d)],[Product Value],"")

Alternatively, if you like to spell things out, you can do the following (just make sure you put the "endif" at the end):

IF ([Start Date]=[DateTimeNow(%Y%m%d)]) Then [Product Value] Else "" Endif

Hope that helps!

arnorian

Nicole,

That kind of worked but now I'm receiving 'Parse Error at char: Unknown variable 'DateTImeNow(%y%m%d).

Isn't DateTimeNow() a native formula that defined within Alteryx and just populates today's date. Which confuses me as to why would it need to be defined as a variable?

All comments

NicoleJohnson

If you are using an IF statement with commas instead of the words "then" & "else", you need to use IIF (two letter I's)... so:

IIF([Start Date]=[DateTimeNow(%Y%m%d)],[Product Value],"")

Alternatively, if you like to spell things out, you can do the following (just make sure you put the "endif" at the end):

IF ([Start Date]=[DateTimeNow(%Y%m%d)]) Then [Product Value] Else "" Endif

Hope that helps!

arnorian

Nicole,

That kind of worked but now I'm receiving 'Parse Error at char: Unknown variable 'DateTImeNow(%y%m%d).

Isn't DateTimeNow() a native formula that defined within Alteryx and just populates today's date. Which confuses me as to why would it need to be defined as a variable?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703