[SalesForce] How do we get the last day of the month from a given date

Is there a function or method to give the last day of a month?
For example
if the date is 27 feb 2013, the last date should be 28 feb 2013 , it become 29 if its a leap year. if the date was 2 jan then it should return 31 Jan.

If there is no function then any ideas on how we can get this?

Thanks

Best Answer

Check out salesforce documentation on their Date class.

The method you are looking for is daysInMonth(...)

Integer numberOfDays = Date.daysInMonth(dateField.year(), dateField.month());
Date lastDayOfMonth = Date.newInstance(dateField.year(), dateField.month(), numberOfDays);

Keep in mind "dateField" above is a place holder for any Date variable or field you want to go off.

Related Solutions

[SalesForce] last 24 hrs of date field

So you want to be able to query an object where a date has a date time value within the last 24 hours?

I think that you need to change your field from date to datetime if you want to get that data.

It's hard to tell exactly what you are doing wihout seeing your code but maybe try using system.now() instead of date.today() // OR datetime.now() either way

Run this in execute anon to see what I mean

  Date TodayDate = date.today();
  DateTime NowDate = datetime.now();
  DateTime Past24 = system.now().AddDays(-1);

  system.debug('OriginalDate::' + TodayDate);
  system.debug('NowDate::' + NowDate);
  system.debug('Past24::' + Past24);

If that doesn't help please post your code.

Best Answer

Related Solutions

[SalesForce] last 24 hrs of date field

Related Topic