No announcements

values between sat 2100hrs to sun 0400 hrs

Requirement Day and times needed are Saturday 2100hrs through to Sunday 0400hrs years data needed for 2009 2010 ,2010-2011, 2011-2012 date format should be split into ...
| 1 Replies | 1774 Views | Created by rams531 - Wednesday, December 5, 2012 2:04 PM | Last reply by SergNL - Wednesday, December 5, 2012 2:17 PM

find the day as sat or sun

Hi All, I have to find the day ,which is saturday or sunday based on that i need to do some calc.How to find the day as saturday or ...
| 2 Replies | 3610 Views | Created by Ramu Sql - Friday, February 17, 2012 1:04 AM | Last reply by Eileen Zhao - Tuesday, February 21, 2012 8:48 AM

Number of Sat, Sun in a year

User-719153870 posted Hi winseealn, In addition to @limno's reply, you can also refer to below demo which is built based on very basic Transact-SQL and ...
| 3 Replies | 89 Views | Created by Anonymous - Monday, January 6, 2020 6:10 PM | Last reply by Anonymous - Tuesday, January 7, 2020 1:59 AM

Calculate the number of years to double a number

I am trying to figure out how to calculate the number of years it takes to double a user defined number.
| 2 Replies | 2815 Views | Created by Audrey1975 - Thursday, April 28, 2011 5:52 PM | Last reply by Audrey1975 - Thursday, April 28, 2011 7:34 PM

Date Year and month number

hi all, how do I get the  year number YYYY and Month number MM i.e.
| 4 Replies | 2156 Views | Created by Milli_22 - Sunday, July 7, 2013 11:28 PM | Last reply by balakrishna141 - Monday, July 8, 2013 3:55 AM

formula with number of days to number of years and months

I use the sourcedate-hiredate for number of days for each record Well, then you have two dates, you can compute year(sourcedate)-year(hiredate) for the ...
| 15 Replies | 1797 Views | Created by CaleCrow - Wednesday, March 9, 2016 3:36 PM | Last reply by Olaf Doschke - Sunday, March 13, 2016 5:47 PM

how to get the number of saturday and sunday of the specific month and year

It does not appear to answer the count or number of Saturdays and Sundays in any given month and year , which, to me, was the original ...
| 9 Replies | 3944 Views | Created by dchallenger - Tuesday, November 16, 2010 1:42 AM | Last reply by John Anthony Oliver - Tuesday, November 16, 2010 3:35 PM

Number of Days in a Year

I think subtract 1 year and take datediff will work.
| 12 Replies | 1494 Views | Created by Kalman Toth - Friday, August 23, 2013 9:41 AM | Last reply by Jingyang Li - Friday, August 23, 2013 3:15 PM

cal sat & sunday

"Weekend days for " + CMONTH(ldStartDate) + STR(YEAR(ldStartDate), 5), lnWeekendDays You should also consider national holidays and student vacation day which ...
| 9 Replies | 3713 Views | Created by wongkk - Tuesday, July 20, 2010 3:20 AM | Last reply by Pavel Celba - Wednesday, July 21, 2010 2:33 PM

Hiding/removing Weekends (Sat and Sun) from SharePoint calendars.

We have a requirement to hide/remove Weekends (Saturday and Sunday) from SharePoint calendars in our intranet application running on SharePoint 2010. I have read and tried all previous "related ...
| 16 Replies | 29520 Views | Created by Naveed DG - Monday, October 7, 2013 5:57 PM | Last reply by Zen755 - Sunday, April 2, 2017 6:07 AM

C# - How to convert fractional years (say 1.25 years) to number of days

I have a table that shows periods like 1 year to 10 years.
| 1 Replies | 1791 Views | Created by bnathreddy - Wednesday, February 13, 2013 5:25 PM | Last reply by Reed Copsey, Jr - Wednesday, February 13, 2013 5:29 PM

Last six weeks dates for this year vs last year with closest comparative week day to the current

Shouldn't it be a previous year date for PrevYrDate_ByWkDay field value?
| 24 Replies | 983 Views | Created by ShyamCharan - Sunday, October 7, 2018 6:04 AM | Last reply by ShyamCharan - Wednesday, October 10, 2018 8:05 PM

53 weeks in a year

With datepart function you will get 53 or 54 (as pointed out by wisepin jan 1st is on A Sat or fri with leap year.. e.g Year 2000) as it is just Week ...
| 8 Replies | 10052 Views | Created by Milli_22 - Monday, March 30, 2009 2:17 PM | Last reply by RBarryYoung - Monday, March 30, 2009 11:46 PM

Calculating total number of working hours per year

Andrey, At my last consulting gig, we calculated this in the resource sheet using a custom number field with the following ...
| 7 Replies | 11387 Views | Created by Andrey Kazak - Wednesday, February 22, 2012 7:46 AM | Last reply by Jan De Messemaeker - Project MVP - Monday, February 27, 2012 11:35 AM

create record number with prefix "IE" - year as of today - and autoincrementing number

I do want the record number to start at "001" each year.
| 18 Replies | 1917 Views | Created by jazpervision - Thursday, June 18, 2015 5:29 PM | Last reply by Alphonse G - Friday, June 19, 2015 7:54 PM

PowerShell: Get Date based on Week Number of Year...

This was also posted in ITCG and was answered there:
| 2 Replies | 1544 Views | Created by BenGiacaman - Saturday, March 19, 2016 11:50 PM | Last reply by Mike Laughlin - Monday, March 21, 2016 12:44 PM

Date dimension with distinct quarter numbers of year

or you have created a composite key for key value of quarter number?
| 3 Replies | 5411 Views | Created by dcamanni - Wednesday, January 5, 2011 4:33 PM | Last reply by PCGD - Wednesday, January 5, 2011 5:27 PM

How to Read : Hue, Sat, Lum values in color

Please Write Code - RGB to HSL conversion  and  HSL to RGB  conversion   Hue  Sat  Lum       ...
| 3 Replies | 4722 Views | Created by A.Ankit - Sunday, May 12, 2013 7:56 AM | Last reply by Alaa Mukhtar - Tuesday, May 14, 2013 7:19 AM