date

  1. S

    Problem with comparing dates and times

    Hi All, I have a problem trying to compare two dates in vb.net... is there a bug in .net?? Please see attached code... you can see the values in the two date variables, but the result of the if statement is going to 'else'... i thought = 0 means the two are equal??? Any help would be very much...
  2. D

    Question Filtering a BindingSOurce and Datagridview by Date

    Hi, I am trying to filter a binding source by a date field in a datagridview (using vb.net 2010 and sql server 2008) Now my filter works for names no problem but not for dates ! Dates in the database are proper dates in the yyyy/mm/dd format ! Heres my code I followed an example on the web...
    • divjoy
    • Thread
    • binding date filter source
    • Replies: 5
    • Forum: SQL Server
  3. C

    Question Check date modified of multiple files on FTP

    Hi, i'm new to these forums so sorry if i'm posting in the wrong section. I am attempting to open a folder in FTP, and check the date modified of ALL files in that folder. I then want to compare that to the date modified of files on my computer. Is there any way I can do this? I figured out...
  4. VBobCat

    Question Issue passing Now as OleDbParameter in Update Query

    Hello people, I'd like you to help me figure out this. I've added a field to one given table of my database. Its datatype is DateTime, for I want to store in it the date/time of each record's last update. These updates were being successfully done with a SQL "UPDATE TABLE" query, passed with...
    • VBobCat
    • Thread
    • date oledbparameter parse system.datetime.now
    • Replies: 7
    • Forum: MS Access
  5. A

    Question SQL dates - Nullreferenceexception was unhandled error

    I have a Monthcalendar from which a date is chosen and a button is clicked. I can store this and have tried formatting it a number of ways so it can be used in an SQL statement to list all incidents which were recorded after that date. PrivateSub MonthCalendar1_DateSelected(ByVal sender...
    • Andy Kerr
    • Thread
    • date nullreferenceexception sql
    • Replies: 11
    • Forum: OLEDB
  6. J

    Get a list of dates using start date and end date range

    Hi I am trying to get a list of dates from a provided StartDate and EndDate in my database, and use these dates to link to dates in a database (to display another variable on the y-axis of the chart) and to populate the x-axis of a chart (with the list of dates). Is it possible to get a list of...
  7. K

    Question Comparing dates PLEASE HELP!!

    Hi! I am new to this forum and to programing in visual basic .net! I am sure there is an easy solution but I am stuck!! I have a question: I have a program with a SQL 2008 backend with a table called p_timesheets inside of which is a field called tsDate stored as date. I am able to pull the...
    • kat333
    • Thread
    • compare dataadapter datatable date
    • Replies: 3
    • Forum: ADO.NET
  8. A

    Question Date Problem

    Hi, I want biweekly start date and biweekly end date. For Example: If i select date from datepicker 12/14/2009 and week start day is monday then start date should be 11/30/2009 And End Date should be 12/13/2009. And if i select date from datepicker 12/15/2009 and week start day is monday...
  9. C

    Question Inserting Dates into MSSQL DB

    Hello Guys I am trying to insert a date into a MSSQL database which is set to a DateTime field but it always inserts in at 01/01/1900 I am using a masked text box that is set to the short date mask. Any ideas? Also when I try to set a default date on a datetime field it will also insert as...
  10. V

    Problem using DateTimePicker control

    Hi I am using a DateTimePicker control in my vb.NET application. The date can be entered by the user in runtime instead of selecting when I do not set it to custom mode. But I want set it in custom mode as DD/MM/YY instead of the default MM/DD/YY format. When I do so the date can only be...
Back
Top