如何在vb.net中更改DateTimePicker的日期格式

3 回答

• 13

  您需要将DateTimePicker的格式设置为自定义，然后分配CustomFormat .

  Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
      DateTimePicker1.Format = DateTimePickerFormat.Custom
      DateTimePicker1.CustomFormat = "dd/MM/yyyy"
  End Sub
  

  回复于 2024-04-30T00:00:19+08:00
• 8

  使用：

  dateTimePicker.Value.ToString("yyyy/MM/dd")
  

  请参阅以下链接：

  http://www.vbdotnetforums.com/schedule-time/15001-datetimepicker-format.html

  回复于 2024-04-30T00:00:19+08:00
• 3

  试试这个代码吧：

  Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
  Dim CustomeDate As String = ("#" & DOE.Value.Date.ToString("d/MM/yyyy") & "#")
      MsgBox(CustomeDate.ToString)
  
      con.Open()
  
      dadap = New System.Data.OleDb.OleDbDataAdapter("SELECT * FROM QRY_Tran where FORMAT(qry_tran.doe,'d/mm/yyyy') = " & CustomeDate & "", con)
  
      ds = New System.Data.DataSet
      dadap.Fill(ds)
      Dgview.DataSource = ds.Tables(0)
      con.Close()
  

  注意：如果您使用 dd 进行日期表示，则在选择1到9时将不返回任何内容，因此请使用 d 进行选择

  'Date time format
  'MMM     Three-letter month.
  'ddd     Three-letter day of the week.
  'd       Day of the month.
  'HH      Two-digit hours on 24-hour scale.
  'mm      Two-digit minutes.
  'yyyy    Four-digit year.
  

  documentation包含日期格式的完整列表 .

  回复于 2024-04-30T00:00:19+08:00