SQL Server Query Statement Get Last Previous Working Day 


SELECT  DATEADD(DAY, CASE DATENAME(WEEKDAY, GETDATE()) 
                        WHEN 'Sunday' THEN -2 
                        WHEN 'Monday' THEN -3 
                        ELSE -1 END, DATEDIFF(DAY, 0, GETDATE()))

Comments

Post a Comment

Popular posts from this blog

How to remove app from SharePoint 2013/2016

I have installed an SharePoint App for creating surveys but when try to uninstall / remove it from the site it shows exception message " sorry we couldn't remove the app ". Solution: I have used following Power-Shell commands to install/remove app successfully  $instances = Get-SPAppInstance -Web <URL> $instance = $instances | where {$_.Title -eq '<app_title>'}   Uninstall-SPAppInstance -Identity $instance
Read more

The model backing the context has changed since the database was created. Consider using Code First Migrations to update the database

One way to resolve this error is to use Code First Migrations to update the database schema to match the new model. To do this, you can use the following steps: Open the Package Manager Console in Visual Studio by going to Tools -> NuGet Package Manager -> Package Manager Console. In the Package Manager Console, run the command Enable-Migrations to enable migrations in the project. Run the command Add-Migration <migration-name> to create a new migration for the changes you made to the model. Run the command Update-Database to apply the changes to the database.
Read more