No announcements
Found 562994 threads
-
0 Votesvalues 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 ...Answered | 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
-
0 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
0 Votes
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.Answered | 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 -
0 Votes
Date Year and month number
hi all, how do I get the year number YYYY and Month number MM i.e.Answered | 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 -
0 Votes
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 ...Answered | 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 -
6 Votes
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 ...Answered | 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 -
0 Votes
Number of Days in a Year
I think subtract 1 year and take datediff will work.Answered | 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 -
2 Votes
cal sat & sunday
"Weekend days for " + CMONTH(ldStartDate) + STR(YEAR(ldStartDate), 5), lnWeekendDays You should also consider national holidays and student vacation day which ...Answered | 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 -
4 Votes
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 ...Answered | 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 -
1 Votes
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.Answered | 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 -
1 Votes
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?Answered | 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 -
2 Votes
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 ...Answered | 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 -
0 Votes
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 ...Answered | 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 -
1 Votes
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.Answered | 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 -
0 Votes
PowerShell: Get Date based on Week Number of Year...
This was also posted in ITCG and was answered there:Answered | 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 -
0 Votes
Date dimension with distinct quarter numbers of year
or you have created a composite key for key value of quarter number?Answered | 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 -
2 Votes
How to Read : Hue, Sat, Lum values in color
Please Write Code - RGB to HSL conversion and HSL to RGB conversion Hue Sat Lum ...Answered | 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 -
0 Votes
Looking for Sun Virtualbox stencils..
If Sun hasn't got it on their site, you may have to purchase it from a third party (you might check out www.altimatech.com).Answered | 2 Replies | 9365 Views | Created by tee2010 - Wednesday, December 29, 2010 8:59 PM | Last reply by tee2010 - Thursday, December 30, 2010 8:33 PM -
0 Votes
Working Sat & Sun does it count in summary task?
In the new calendar you create make sure Sat and Sun are working days.Answered | 2 Replies | 9575 Views | Created by jp-pm - Monday, January 24, 2011 9:56 PM | Last reply by jp-pm - Monday, January 24, 2011 11:51 PM - Items 1 to 20 of 562994 Next ›
No announcements
