[dba-VB] VB.Net Date/time in specific format

Doris Manning mikedorism at verizon.net
Mon May 5 10:46:24 CDT 2008


Try using... Format(Date.Now, "yyyyMMdd-hhmmss")

Doris Manning
Database Administrator
Hargrove Inc.

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Monday, May 05, 2008 11:23 AM
Subject: [dba-VB] VB.Net Date/time in specific format

I need to get the current date / time in a format that does not include 
: or /, IOW "20030123-082347".  I need it in this format for appending 
to a file name so that the name is unique and sorts in the directory.

Has anyone already done this, or know how it is done?  I can get the 
year part etc., but I am not finding hour, minute or second, and I am 
just wondering if someone has code already built.

John W. Colby
dba-VB mailing list
dba-VB at databaseadvisors.com

More information about the dba-VB mailing list