format date7time in vb.net

  • Thread starter Thread starter pp
  • Start date Start date
P

pp

I have this kind of format dates "02-01-2001 16:00" in a excel
spreadsheet (dd-mm-aaaa h:mm).

In vb.net I have this code:
Dim tempo As string
tempo=oExcelWs.Cells(i, 1).Value

and I get this date: tempo = "01-02-2001 16:00", the code have switched
the month whit the day.

Can anyone help me?
Thanks
Paulo Praça
 
Try this:

Dim tempo as String
tempo = Format(oExcelWS.Cells(i,1).Value, "dd-mm-yyyy h:mm")

Let me know if that works.

Mark
 
Mark said:
Try this:

Dim tempo as String
tempo = Format(oExcelWS.Cells(i,1).Value, "dd-mm-yyyy h:mm")

Let me know if that works.

Mark
Click to expand...
Thanks Mark,
I solve my problem this way:


dim time as DateTime
Dim MyDateTime As String

MyDateTime = time.ToString("dd-MM-yyyy h:mm")

Paulo Praça
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formate dates in vb.net 5
format date/time excel in Vb.net 2
Using VBA to create charts 1
Problems with the excel find function in vb.net 2
Excel is changing date format incorrectly 7
Calculating occupational sick pay entitlement 0
Using "dd/mm/yyyy h:mm" on Date Variables 1
How do I add numbers in two column based on the date in another? 2

Back
Top