Token Comma Error w/ If Statement

Question

Hey Everyone - I have this formula in Power Query that looks like this:

=if [Provided Date]>= Date.From(DateTime.LocalNow() then "Up To Date" else 0

I'm trying to have it look at the "provided date" and if it's >= whatever the current date is, list it as "up to date".

I keep getting a token comma expected error and can't figure this one out - can anyone help?

mahoneypat · Accepted Answer

You need to close parentheses for your Date.From. Add another after .LocalNow())

If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.

Regards,

Pat

Forum Discussion