[SalesForce] how to convert the number of days of year into Date in salesforce

I'm stuck with a requirement here.
I have a Julian date of the format "115090".
Here.. 1 - denotes the century i.e 20th Century. 
15 - denotes the year of the century i.e. 2015. 
(Until this part I'm able to convert the YEAR part of the Standard Salesforce DATE) 
090 - denotes the NUMBER of days for the year 2015. 
(090 - 31 days of Jan + 28 Days of FEB + 31 Days of Mar)
So , Typically 115090 should return 31-MAR-2015 or 31/03/2015. 

All I'm able to get is the YEAR of the DATE 

IF(
   BEGINS(Alert_Date__c , "1"),
   2000 + VALUE(MID(Alert_Date__c,2,2)),NULL
)


I'm Not able to convert the number of days of the year i.e. 090 to 31/03.
If am not wrong , in no. of days, i have to check for LEAP year as well.
please provide some assistance.

Best Answer

You know the year so can create a DATE for Jan 1st and then add your day offset. Using your example you would create the date using DATE(2015, 1, 1) and then add 89 (90 - 1) days.

DATE(theYear, 1, 1) + (numberOfDays - 1)

You don't need to handle leap years using this approach.

Related Solutions

[SalesForce] How to add days to a date field that spans over a year

Taking advantage of the fact that end of month X is the day before the first of month (X + 1), and using MOD() to handle the month rolling over into the new year:

CASE( 
  Payment_Terms__c, 
  'Net',     DATE( YEAR(TODAY()) + IF( MONTH(TODAY()) > 11, 1, 0), MOD( MONTH(TODAY()) + 0, 12) + 1, 1) - 1, 
  'Net 30',  DATE( YEAR(TODAY()) + IF( MONTH(TODAY()) > 10, 1, 0), MOD( MONTH(TODAY()) + 1, 12) + 1, 1) - 1, 
  'Net 60',  DATE( YEAR(TODAY()) + IF( MONTH(TODAY()) >  9, 1, 0), MOD( MONTH(TODAY()) + 2, 12) + 1, 1) - 1, 
  'Net 90',  DATE( YEAR(TODAY()) + IF( MONTH(TODAY()) >  8, 1, 0), MOD( MONTH(TODAY()) + 3, 12) + 1, 1) - 1, 
  'Net 120', DATE( YEAR(TODAY()) + IF( MONTH(TODAY()) >  7, 1, 0), MOD( MONTH(TODAY()) + 4, 12) + 1, 1) - 1, 
  '30', TODAY() + 30,
  '60', TODAY() + 60,
  '90', TODAY() + 90,
  TODAY()
)

So, for Net terms where we want the end of the current month, we find the start of next month and subtract 1 from it to get the end of this month:

YEAR(TODAY()) + IF( MONTH(TODAY()) > 11, 1, 0): next year if it's December, otherwise this year.
MOD( MONTH(TODAY()) + 0, 12) + 1: next month, rolling from 12 to 1
DATE( Y, M, 1) - 1: the last day of the previous month

The Salesforce date-handling routines take care of knowing what the previous month was (even if it's in the previous year) and how many days it has (even on leap years).

The following terms just repeat the same pattern.

[SalesForce] Subtract date days from number (except weekend days) using apex class

I have found the solution with below code and it will executed perfect.

   public static Date calculateWeekDaysforReleaseDateTarget(Date EstimatedDate, Integer targetDays){
            Date ReleaseDate = EstimatedDate.addDays(-targetDays);

            Integer nonWorkingDays = 0;
            Integer currentDay;
            for(Integer i=0; i <= ReleaseDate.daysBetween(EstimatedDate); i++) {
                currentDay = Math.MOD(Date.newInstance(1990,1,7).daysBetween(ReleaseDate.addDays(i)),7);
                if(currentDay == 6 || currentDay == 0) {
                    nonWorkingDays++;
                }
            }

            ReleaseDate = ReleaseDate.addDays(-nonWorkingDays);

            Datetime dt = DateTime.newInstance(ReleaseDate.year(), ReleaseDate.month(), ReleaseDate.day());
            if(dt.format('E') == 'Sat'){
                ReleaseDate = ReleaseDate.adddays(-1);
            }
            else if(dt.format('E') == 'Sun'){
                ReleaseDate = ReleaseDate.adddays(-2);
            }

            return ReleaseDate;
    }

Best Answer

Related Solutions

[SalesForce] How to add days to a date field that spans over a year

[SalesForce] Subtract date days from number (except weekend days) using apex class

Related Topic