Generate all days of a month in Excel

By on

 


Formula to get Number of days in the month (B2): =DAY(EOMONTH(B1,0))

Formula to generate all the days:  =DATE(YEAR(B1),MONTH(B1),SEQUENCE(B2))

Popular posts from this blog

Send Purchase Orders to Vendor collaboration for Vendor Review in D365FO

By on
 Code snippet to send purchase orders for external vendor review (in  Vendor collaboration module)             try             {                 PurchTable purchTable = PurchTable::find(PurchId);                   PurchFormLetter purchFormLetter = PurchFormLetter::construct(DocumentStatus::ConfirmationRequest);                   purchFormLetter.update(purchTable, strFmt("Sent for vendor review",purchTable.PurchId));             }             catch (Exception::Deadlock)             {              }
Read more

Remove Prefix from a String in D365FO

By on
Code to remove any specified prefix from a string value. (Example: Remove '0' from '000018743') public static str stringWithoutPrefix(str _strValue,str _prefixToRemove)     {         str s1 = _strValue;         str s2 = _prefixToRemove;         int i = 0;         int whereFound;         for(i= 0; i < strlen(s1); i++)         {             whereFound = strnFind(s1, s2 , 1, strLen(s1));             if(whereFound > 1)             {                 s1 = strdel(s1,1,1);             }         }         return s1;     }
Read more

Odata Patch operation using Postman

By on
Script to update records using Postman. By default, system will consider the legal entity associated with the user added in Microsoft Entra ID applications for postman client id. Patch Operation: Example: URL:  {D365URL}/data/{Entity name}(dataAreaId='abcd', Unique field= 5637182305)//  Body: {     "Comment": "Test" }
Read more