I 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 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 RepliesIn 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 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
I 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 RepliesHow 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 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 RepliesHow can I replicate this in javascript?Now.Ticks.ToString
View 5 Repliesi want to insert booking_no as combination of year and sno(year/sno) into database here iam giving the code as follows,,,,,,,,,
here sno stated from 1.........
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("guest1").ConnectionString())
Dim booking_no, sno As String
If Len(sno) = 1 Then
[code]....
but here booking_no was not inserted properly,it was inserted as "0/ ",,iwant to insert booking_no as "2010/sno" ,
how to validate the day if the selected year is a leap year in combo box.
View 1 Replieshow 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
I am useing Visual Basic 2008 and on a form....
....how do i display the week Number only in a textbox or label
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.
How To Get Day Of The Week for example : on label1. I 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")
end if
if label1.text = "Sunday" then
Shell("Shutdown -s -t 1")
end if
I have an application with a button on it which launches a backup program. I actually want to backup it each week. So when you launch the program, it looks if its time to backup. What code could i use, i don't really think i need to be saving things in text files, do i ?
View 4 Replies
