code for td stamp

B

BorisS

I need VB code which will type "{Current Date}, "Current Time}", obviously
replacing the words here with the actual values at that time. If there is a
choice (I am thinking of Excel here), I would love to have Date in "Tue,
04-Jan-05" format and time in military format.

Thx for any help.
 
J

John

BorisS said:
I need VB code which will type "{Current Date}, "Current Time}", obviously
replacing the words here with the actual values at that time. If there is a
choice (I am thinking of Excel here), I would love to have Date in "Tue,
04-Jan-05" format and time in military format.

Thx for any help.

Boris,
You didn't say where you want to put the date/time stamp but here is the
basic syntax.
dateformat(now,pjdate_ddd_mm_dd_yy_hh_mm)

As long as the regional time setting on your PC is for 24 hour
designation, you will get the equivalent of military time.

John
Project MVP
 
M

Mike Glen

Hi Boris,

Next time, please post on the developer newsgroup. Please see FAQ Item: 24.
Project Newsgroups. FAQs, companion products and other useful Project
information can be seen at this web address: http://www.mvps.org/project/.

Mike Glen
Project MVP
 

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

td stamp 2
Time Stamp 5
Insert or update record with vba and ado 2
Time/Date Stamp 3
Unhide column difficulty 3
Sumproduct with variation 1
Code to save Word-document do not work properly 3
Code for date stamp 3

Top