Usually in SQL, date gets saved as ‘2009-07-27 00:00:00.000’ but when we run the query or call date from any application the SQL gives us the date in desired format like ’07/27/2009’. How does it work? SQL has set of formats according to the different languages for example ‘British’, ‘Dutch’, ‘German’, ‘English’ etc. By Default… Read More: Change Default Language/ Date Format in SQL »
Do you want to use the same DateFormat which is selected for Current LoggedIn User? To Retrive the same you can use the below mentioed script. You need to provide the User ID and it will return the DateFormat.
Now we can Schedule the tasks and appointments End Date excluding the Weekend and Federal Holidays. Below Mentioned Federal Holidays will be taken care of with this Script. New Years Day: Tues., Jan. 1 Martin Luther King, Jr.: Mon., Jan. 21 Washington’s B’day: Mon., Feb. 18 Memorial Day: Mon., May 26 Independence Day: Fri., July… Read More: Date Calculation considering Federal Holidays. »
