Skip to main content
Topics#Data ManagementLorena Alfonso's Question
Lorena Alfonso asked in #Data Management
Mar 1, 2021, 8:23 PM

Help converting formula from business day to the 1st of the month

I have the following formula below. What I want the formula to do is move the date to the 1st of the following month. This formula creates a date for the next business day.

 

CASE (MOD (DATEVALUE ( Schedule_Paradox__c ) - DATE (1900, 1, 7), 7 ),

 

0,  Schedule_Paradox__c + 1 + 1,

 

1,  Schedule_Paradox__c + 0 + 1,

 

2,  Schedule_Paradox__c + 0 + 1,

 

3,  Schedule_Paradox__c + 0 + 1,

 

4,  Schedule_Paradox__c + 0 + 1,

 

5,  Schedule_Paradox__c + 2 + 1,

 

6,  Schedule_Paradox__c + 2 + 1,

 

Schedule_Paradox__c + 1
2 answers
  1. Tony Trinh
    Mar 1, 2021, 8:34 PM
    Hi Kenneth,

     

    I don't think this formula has any relevance to moving the date to the first of the month. Do you just want to calculate the first of the next month from the Schedule_Paradox__c, which is a date/time field? Try this:

    DATE(
    YEAR(ADDMONTHS(DATEVALUE(Schedule_Paradox__c), 1)),
    ​​​​​​​MONTH(ADDMONTHS(DATEVALUE(Schedule_Paradox__c), 1)),
    ​​​​​​​1)
Write an answer...
0/9000