Date Format: 06 wk38.2

[HansPM]

Hi,

Being a total lamen to VBA, I'm trying to use the build-in 'code generator'
without any succes at all to make a date format which looks like:
"06 wk38.2"
which represents the date of today 19 sept 2006. I need to use this
format for start and finish dates. There is a standard format in project
that looks like it but adds the time as well, and that is info I do not need.

Thanks!

Hans

 

[Jack Dahlgren]

Hi,

Being a total lamen to VBA, I'm trying to use the build-in 'code generator'
without any succes at all to make a date format which looks like:
"06 wk38.2"
which represents the date of today 19 sept 2006. I need to use this
format for start and finish dates. There is a standard format in project
that looks like it but adds the time as well, and that is info I do not need.

Thanks!

Hans

Hans,

You will have to use the FORMAT function and some string concatenation for
this. I used to have the formula handy, but I'm away from that computer. Look
at the help for the format function. The best way to do this is to use a
custom field formula in one of the spare text fields. You won't be able to
change how project displays the start and finish if you want something non-
standard, but you can put the formatted value in a text field and display that
instead of the start/finish

-Jac