Skip to main content
Topics#FormulasRasmita Rani Sahoo's Question
Rasmita Rani Sahoo (salesforce) asked in #Formulas
Sep 12, 2022, 1:44 PM

date field only the last friday of the month

Create one date field for validation. This field only receive the last friday of every month. Please help me out.
1 answer
  1. VINAY KUMAR K (Salesforce)
    Sep 12, 2022, 2:46 PM
    Hi Rasmita,

    Can you try below validation rule.

     

    IF(OR(DAY(Date_field__c) =28, DAY(Date_field__c) =29, DAY(Date_field__c) =30, DAY(Date_field__c) =31),true, false)

    Please mark as Best Answer if above information was helpful.

    Thanks,
Write an answer...
0/9000