I am supposed to create a program that converts a number into the date that the number represents. its has to list today's date the date the number represents and the difference between that date and today 0 represents December 31st 1899
View 2 RepliesI want to convert e.g. 21/06/2009 15:30:00 to seconds or a decimal number. Just like PHP, which uses a reference date (01JAN1970)
View 4 RepliesI am attempting to import data in a batch from an Excel Worksheet to a Sql Server database. Everything works except for the one date field in the spreadsheet. The date returned is off by four years from the value in the spreadsheet. Example: The Excel sheet has a date 10/24/2010 14:18, but when I look at the column in my query, the date is 10/23/2006 2:18. This pattern, 4 years and 1 day earlier, is repeated for every row in the worksheet.
The Excel column comes to me as a custom type, formatted m/d/yyyy h:mm. I receive this from an outside vendor and having them change the column is not going to be my simplest solution.
For what it's worth, the relevent part of the query is:
Select [Date Created] From MyWorksheet
I am using VB.NET. Is there a date function that calculates the date based on the number of months I have given?
for example, if i say July 2009 and looking for 10 months back, it should return Sept 2008.
I have a string that holds a value in the format of ddMMyyhhmmss.
Example 240512024707
I need to be able to convert this date to a real .NET Date object.
I am currently using CDate but it seems CDate does not recognize the format, is there any way of specifying the string format to CDate ???
row.Item("NoteDate") = CDate(n.noteText.Substring(0, 12).ToString).ToString("dd/MM/yyyy hh:mm:ss")
I want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
I 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 would like to write a calendar. That will convert gregorian date to hijri date. I did it. But i cant display months can you show me how can i?
i changed it as for example:
When i run the programme:
1981 is equals to the 1401
But i would like to change like 21 Ocak 1981 equals to the 16 Muharram 1401
cant seem to get this to work , I am tryin gto get the date from last week exactly 7 days ago i get an error when i try this "cannot convert to date "
Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim dateTimeInfo As Date = Date.Now
MessageBox.Show(dateTimeInfo.Date.ToString(Format(DateAdd("", -7, "yyyyMMdd"))))
txtFileDate.Text = ""
End Sub
Is there any way to get the date (from Today.Date/User input) to a whole number and then return it to a date string?Only way I have so far thought of is:[code]
View 11 Repliesim having trouble understanding this question for a homework assignment. I need to write the PSEUDOCODE for the following scenario, but i got no idea about how to convert a hexadecimal number to a decimal number..You are required to input a two digit hexadecimal number eg. 3f (digits can be entered separately) and calculate the equivalent decimal number. (note the decimal number will be between 0 and 255) . output the decimal number
View 1 RepliesI want to get the difference of date from Two TextBox say to and from dates.[code]...
View 4 RepliesI am debugging an application that I ported from Windows, to *nix, a little while ago. The app stores dates as doubles (using the OLE Date format). I need to be able to inspect the dates - as human readable strings. I cant find an online conversion tool, so I decided to roll my own.
I was originally going to write an OpenOffice function, but I think it would be more straightforward to use one of the .Net languages, to write a small console app that accepts the double as a parameter and prints the date string to the console.
I am relatively new to .Net (though I have dabbled with both C# and VB.Net in the past). Can anyone help with my main() function? - snippets in either VB.Net or C# will be equally useful.
I have a date in the future e.g. 13/10/2008 I need to subtract the current date (today is the 28/09/2010) minus 7 days, so thats 21/09/2010 minus 13/10/2008, which would equal erm, 720 something ? But the current date won't always be 28/09/2010, obviously. I need the code for this. EDIT: When i said future I mean past :)
View 3 Repliesi cant seem to create a datetime object in vb.net with datetime string that's in this format "hh:mm:ss tt MM/dd/yy".The error im getting says its not a recognisable string datetime format.
View 15 RepliesHow to convert text value into date
Textbox1 column value = 31/12/2009 (dd/MM/yyyy)
Tried
Cdate(textbox1.text)
The above code is not working.I want to get a date like this '31 Dec 2009'How to write a code for getting this format.
I want logging functionality in my application and this is how I do it:
My.Settings.LastRun = Now()
lblLastRun.Text = My.Settings.LastRun.ToString("yyy-MM-dd hh:mm:ss")
s = "Operation finished: " & My.Settings.LastRun
[code].....
How do you get the current date "2/23/09" but you will only display the day for to day which is "23"? What is the code to format the date that will display only the day
View 6 RepliesI have a date like this 2/25/2011 but I would like it 25/2/2011. How can I do it?
View 2 RepliesI am trying to convert a string into Date (to put it later into INSERT command). My problem is that the string I am reading is always different (there is no rule what format it is going to be - as this is user-dependent).I found such piece of code on the stackoverflow:
DateTime myDate =
DateTime.ParseExact("2009-05-08 14:40:52,531",
"yyyy-MM-dd HH:mm:ss,fff",
System.Globalization.CultureInfo.InvariantCulture)
but in my case it will not work as I don't know what kind of format I am going to import.Is there any universal import function which checks all known formats? If now how should I write it?
I am developing asp.net site using vb framework 3.5. Im having difficulties converting string data into Date I tried using cdate function, I have a variable sdate which is a string variable and date is stored in it which comes from textbox as dd/mm/yyyy now i want to convert this string into a Date variable as i need to perform the operations as Add a day or Subtract a day.
[Code]...
I am retrieving some user info from Active Directory[code]...
how I can display the accountexpires value in a readable format?
I've got a date from my DateTIme field in my database, how can I convery the date from mm/dd/yyyy to dd/mm/yy?
View 6 RepliesI would just like to convert a date, say February 27th, 2009 to its integer value of 39869. I've tried cInt(Today) but of course that's no good.
View 2 Replieshow I can convert date time from dd/mm/yyyy HH:MM:SS to this format 19900101000000.000000+**** as used by WMI? I'm trying to set a schedule for an advertisement in ConfigMgr 2007 using vb.net.
View 3 RepliesI want to insert only date into the db but in the following statement that I've wrote which inserts the date in mm-dd-yyyy hh:mm:ss format.
InsertCmd = "Insert into Blotter (Name, Product, Date_Time) values ('" & NameLabel.Text.Trim() & "','" & ProductTextBox.Text.Trim() & "','" & TimeLabel.Text.Trim() & "')" & "Update Blotter Set Name = UPPER(Name)"
I have tried the following code, however it didn't work.
InsertCmd = "Insert into Blotter (Name, Product, Date_Time) values ('" & NameLabel.Text.Trim() & "','" & ProductTextBox.Text.Trim() & "','" & (CDate(TimeLabel.Text.Trim().ToString("MM/dd/yyyy")))& "')" & "Update Blotter Set Name = UPPER(Name)"
[code]
I also tried format the TimeLabel as below but still didn't work. [code] TimeLabel.Text = CDate(DateTime.Now).ToString("MM/dd/yyy")
I wants to ask how to convert DBNull to Date type?
For Each row As DataRow In dt.Rows
i = 0
Dim array As Object = row.ItemArray
[Code]....
array(i + 10) is datetime type, in the program above, if the Datetime column contains items, it still can run. However, when it loops to a row where the Datetime column does not have value of datetime (or the column is null), then an error " Conversion from type 'DBNull' to type 'Date' is not valid" is occured. I tried to use the if statements as program above but it seems like cannot works.
I want to convert this string"25-06-2011 03-25-34" to date.
But I want the date to have the same format as the string, i mean also 25-06-2011 03-25-34
Just because you know, doesn't mean you should.
how can i convert string "ddmmyyyy" into date dd-mm-yyyy
View 6 RepliesI'm trying to convert a string into a date format My string looks like this Dim MyString as String = "June 2011" And I'm trying to convert it like this
[Code]...