project date format

[Ryan Vande]

Ok so we extract all our data from excel into a project sheet

We have variables setup as mstask.start which equals ["Start Date"] +
["Start time"]


also same for end date and time but we can sum everything up from the start
I believe.

Now the format of these dates come out as 1/01/01 <-- Example

I want to make a programable decision based off day of week of the listed
jobs within our project sheet. So weekday(date) would be nice, but wont this
return the current day. Or can I use weekday(date) against ["Start Date"] ?

I was trying to cstr("Start Date") To try and get this date as a string and
then I can perform some manipulation on it but I was not getting success. I
was going to Trim the string and set up a array (Sort of speak)

Would there be an easy way to go through each row and based off "Start Date"
distinguish which day the date currently falls on? A i heading the right
direction trying to convert this date into a String?

Can I do something like weekday(date #"Start date"#)

Something to that nature?

 

[Jim Aksel]

Might Weekday(date, [firstdayofweek]) help you?
It returns an integer representing the day of the week (1-7), not the
calendar date.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com