In SQL Server, you can use the DATEADD() function to get last 3 months (or n months) records. I have used this function in one of my previous posts where I have shown how easily you can get previous ...
If you have worked with SQL, then I am sure you must have come across the LIKE statement to search a specified pattern in a table. The LIKE in SQL uses a % (percent) sign to fetch a pattern of values. ...
I am sharing three simple methods here, which shows how to pull or read data, as it is, from another Excel workbook, in your computer or from a remote computer. While pulling or extracting the data, ...
In Excel, you can use the “EDate()” method to automatically add one month from the previous date or increment the previous date by one month. ...
You can use the join() method in JavaScript to remove commas from an array. The comma delimiter in an array works as the separator. For example, let arr = ["alpha", "bravo", "charli"]. The join ...
There are many ways you can embed a YouTube video in a web page without IFrame. Although, the iframe is the recommended method for YouTube embeds, if however, you do not want to use iframes, you can ...
You must be familiar with VLOOKUP function and the error #N/A, which the function often throws when it fails to find a lookup value. It can be annoying at times, since #N/A does not explain the error ...
There are many ways to store JSON data for your application. You can store it in an array or in an external file. There are many ways to read JSON data from external files. I have previously shared ...
The URL or the web address will always have a file name, with few parameters occasionally. Sometimes, we might need to know the file name in the URL. There’s a simple technique to extract the file ...
You can use the DataGrid control in Asp.Net to export GridView data to an Ms-Word document. I am sharing codes here, both C# and Vb.Net, which explains how easily you can export data extracted from a ...