Forum Discussion

sestes's avatar
sestes
Regular Visitor
7 years ago
Solved

Yes/No Calculated Column for Last Month

I have the following code to create a calculated column returning "Yes" if the selected date was last month and "No" for everything else.  This was working fine until this month due to the year chang...
Need Help
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    sestes

     

    Hi, In Pquery yo can create a Custom Column with this code.

     

    =if Date.IsInPreviousNMonths([Request_Recieved], 1)=true then "Yes" else "No"

     

    Regards

     

sestes's avatar
sestes
Regular Visitor
7 years ago

Thank you both for the quick reply.  Vvelarde This was exactly what I needed and works like a charm.