Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Power Query Date

Hi all   I am trying to get the date (YYYY/MM/DD) in power query using an IF statement.    I need to have the year dynamic to today's year.    For example if Attribute column is "Production Jan...
  • HotChilli's avatar
    5 years ago

    Can't read the error (the picture is too small).

    Looks like it says error in the cell so just click in the cell - not on the error - and it will display underneath.

    --

    Having said that, it looks like you are creating a #datetime and you want a #date, so try that