In regular SQL i could do something like
SELECT * From T GROUP BY DATEPART(wk, T.Date)
How can i do that in Linq to SQL ?
The following don't work
From F In DB.T Group R By DatePart(DateInterval.WeekOfYear, F.Date)
Also don't work:
From F In DB.T Group R By (F.Date.DayOfYear / 7)
I need to generate a report that shows the 52 weeks of a year (or 53 weeks as some years have) and their start and end dates. There is an ISO spec to do this but seems awfully complicated! Im hoping someone knows of a way to do it in C# or Visual Basic (its actually for Visual Basic 6 but I will try port it across)
View 7 RepliesI m working on a site which requires me to calculate date(s) from the given week number for the year start set by the user in his setup.for ex. user set the year is from 1st April to 31st May in his setup and he selects week say 23rd then I have to find out dates for the week selected.
View 6 RepliesI have following code (in VBA, excell) for calculating a date.I have variable for yeay, weeknumber and daynumber from week, now i wanna calculate the exact date. [code] But when i place this code in vb.net don't get the correct month.It displays correctly the year, day and daynumber but is displays the month as '00'. What do i have to change?
View 2 RepliesI have a code in vb
var weekOfYear=DateAndTime.DatePart(DateInterval.WeekOfYear, date, FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFullWeek);
which is [URL].. I canÄ… find nothing equivalent to this in c¤, but I don't want to create new algorithm, which I think would have some bugs
i am looking for some tip to format a datetime stamp to format Saturday, December 31, 2011. I am able to get day of week, month, year in numbers but not in string. I can create arrays for days,month but i don't want to use lots of memory, if theres a function i can use it.
View 3 RepliesHow to get difference between two dates in Year/Month/Week/Day?
I have a problem with the difference between two dates. I need the out put in 0 YEAR, 0 MONTHS, 0 DAYS LEFTm e.g.:
1 YEAR, 2 MONTHS, 3 DAYS LEFT
With dateDiff function or using anything else it is not pos
How can I find the date of the Sunday of the first full week of a year using the DatePart function or something else? Jan 4 for 2009.
View 3 RepliesI am useing Visual Basic 2008 and on a form....
....how do i display the week Number only in a textbox or label
How can we calculate week number in one month.I am bit confused about caliculating this week number in one month.for example if we take today date 8/12/2006.Now we are in which week ? 2nd or first week (in december month)Our zone is united kingdom..
View 11 RepliesHow can i find the week number in a month.
A month can have 5 weeks, i need to know in which week i am.
I am trying to determine how to take a date and show what the week number is for that month. So 3/1/10 will be week 1, 3/16/10 will be week 3 and 3/30/10 will be week 5. I know how to get the week of the year number just not week of the month.
View 4 RepliesGiven a week number, I need to get the date of the Monday of that week.For example, I have several strings that are stored in a file, such as
"WK 28 2010"
"WK 30 2010"
They could be any any valid week number.
The Monday on Week 28 of the year is 12 July 2010
The Monday on Week 30 of the year is 26 July 2010
Its these dates that I need.
I guess I could create a lookup table, but would prefer a more smarter approach so my software will be future compatible?
How can I set week number of "1/2/2011(Sun)" as 52 of 2010?
When I write as follows, it says week number is "1".
Dim dtTest As Integer = DatePart(DateInterval.WeekOfYear, CDate("2012/01/02"), _
FirstDayOfWeek.Monday, FirstWeekOfYear.FirstFullWeek)
Why is it? I set FirstDayOfWeek as Monday, so week number of "1/2/2011(Sun)" Should be 52, right?
"1/2/2011(Sun)" is just an example.
I want general method to do:
1. First day of week is Monday.
2. First week of year is the first full week which stat with Monday.
3. The last week of year should contain dates before the first week of the next year(such as 1/1/2011(Sat), 1/2/2011(Sun))
how to get the name from dayofweek? [code]
View 3 RepliesSorry in advance. I emailed myself my coding since I don't have vb on my personal computer. Sooo, the format is going to be off. But my program allows the computer to generate a random date. The user has to guess what day of the week the random date lands on. I have written the whole code. It all works except when user checks his/her answer. The answer always comes up as incorrect. Here is the coding:
[code]...
So I can't figure out how to find the first day of the week. I also need it in a format like ("yyyyMMdd")
Right now I only have it telling me its Sunday. I need the exact date.
Dim FDW As Date
FDW = WeekdayName(1, FirstDayOfWeek.System)
MessageBox.Show(FDW)
I need a function that will give me the day of the week for any date...and possible assign the day of the week to a string...
View 1 RepliesI'm having some trouble getting the first day of the current week, then getting the date of that day.
Public NotInheritable Class FirstDayOfWeekUtility
Private Sub New()
End Sub
[Code]......
I have a ComboBox where I select which day of the week I want it to update. And each week at that day, at a predefined time as well I want it to add 1 to an integer. I want it to continue doing this until I stop it. When I close the program I want it to do a check on start up if it has past that set date and time, if it has it should add 1 to the integer again, if 2 weeks have past I want it to add 2 to the integer.
View 14 RepliesHow To Get Day Of The Week for example : on label1I Want To Code The Program That Turns Off The Computer On Saturday And Sunday
label1.text = 'The Day Of The Week Code'
if label1.text = "Saturday" then
Shell("Shutdown -s -t 1")
[code].....
I have this app written in VB.Net with winforms that shows some stats and pictures on a bigscreen monitor.I also monitor the memory usage of sad app by using this. Process.WorkingSet64
I know windows does not always report the correct usage but I just wanted to know if I didn't have any little memory leaks which I had but are solved now. But the first week the memory usage was around 100MB and the second week the memory usage showed around 50MB.
So why did it all of a sudden drop while still running the exact same code?I can hardly imagine that the garbage collector kicked in this late since the app refreshes every 10 seconds and it has ample time in between those periods to do it's thing.Or perhaps there is just better way to get memory usage for a process that is more reliable.
is there any ready to go solution within the microsoft framework, regarding conversion of date to day?For example, i would like to convert this string 21/03/2010 (dd/mm/yyyy) to Sunday?
View 5 RepliesHow do you check the day of the week in VB.net 2003?[code]...
View 3 RepliesCan anyone tell me what the code is for displaying the current day in visual basic on a form in a textbox
ie: Monday,Tuesday ect. day now
Ok so i'm working on this project that requires me to imput a month and year which then will output the number of days in the selected month for you to select from, then determines what day of the week it is. The problem i'm having is that I cant get the month to the converted value that I need for it to work . Example: January will be the 13th month and february as the 14th of the previous year. Heres what i have so far if it helps. Aslo the code that I have to use to find the day of the week only works when the total is divided by 7, and then the value of the remainder is the day of the week with saturday =0, sunday=1, monday=2, and so on.
[code]...
A month consistof weeks and i want to find out which week of the current month.
View 2 RepliesI just want to clarify my select statement if correct to get records from my table. Please see below
List for products 3 months before Expire genReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 3 month ")List of products 2 months before ExpiregenReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 2 month ")List of products 1 month before Expire
genReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 1 month ")
List of products 1 week before Expire genReportExpires("SELECT * FROM t_products WHERE f_expire < #" & Date.Now & "# - Interval 1 week ")
I need to loop through each day of the week (monday tues...) and compare the day to a string.I know I can manually add each day of week to a string array, but that's not what prefer.[code]
View 2 RepliesI have this:
this is a extension method for calculating the dates for a week,
public static IEnumerable<SelectListItem> GetWeekNumbers(this HtmlHelper helper /*Dictionary<int, DateTime> dayOfWeek*/ /*,DateTime allWeeks*/ /*int selectID*/)
{
[Code]....
But how to get an optvalue in asp.net MVC 3.Because the dates has to be saved in the databse.