Forum Discussion

sfalk781's avatar
sfalk781
Icon for Helper II rankHelper II
6 years ago
Solved

Token Comma Error w/ If Statement

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 d...
Need Help
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

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

  • sfalk781's avatar
    sfalk781
    Icon for Helper II rankHelper II
    6 years ago

    Thank you for your help.