preloader-matrix

Alfasith

Date handling in AX 2012

Hi,

dateStartMth and dateEndMth in ax 2012

//Get day from date
dayOfMth(systemdateget())

//Get month from date
mthOfYr(systemdateget())

//Get year from date
year(systemdateget())

// Ger Ist date of the month
dateStartMth (DueDate); // If DueDate = 18111989 this method returns 01111989

// Get Last date of the month
dateEndMth (DueDate) // If DueDate = 18111989 it returns 30111989

// Get no of months between the 2 dates.
noOfMonths =  intvNo(Date1, Date2, intvScale::Month);

// Get no of month between 2 dates belongs to 2 different year.
noOfMonths =  intvNo(Date1, Date2, intvScale::YearMonth);

//for next month
dateLoc = nextMth(today());

//for prevous month
dateLoc=prevMth(today());

//for next year
dateLoc=nextYr(today());

//for previous year
dateLoc =preYr(today());

//4 month before
dateLoc=prevQtr(today());

//4 month after
dateLoc=nextQtr(today());

Regards,

Leave a Reply

Your email address will not be published.