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 = 18\11\1989 this method returns 01\11\1989
// Get Last date of the month
dateEndMth (DueDate) // If DueDate = 18\11\1989 it returns 30\11\1989
// 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,
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 = 18\11\1989 this method returns 01\11\1989
// Get Last date of the month
dateEndMth (DueDate) // If DueDate = 18\11\1989 it returns 30\11\1989
// 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,
No comments:
Post a Comment