Group BY Date Time

[Harry]

I would like to group a series of recurring tasks by the following Dtae and
time grouping structure
Group BY --- 'Start Date'
Then BY --- 'Start Time'

I want to show the date and time in the start finish date columns.
Does anyone know how this can be done. Thanks.

Harry

 

[Brian K - Project MVP]

I would like to group a series of recurring tasks by the following
Dtae and time grouping structure
Group BY --- 'Start Date'
Then BY --- 'Start Time'

I want to show the date and time in the start finish date columns.
Does anyone know how this can be done. Thanks.

Harry

have a Text field use the following formula:
ProjDateConv([Start],pjDate_hh_mmAM)

This will show just the time from the Start field

Then do another one with this formula in it:
ProjDateConv([Start],pjDate_mm_dd_yy)

This will show just the date.

Then do your grouping by these two fields.

 

[Harry]

Brian,
Thanks.. How can I add a Day before the date in the fomula e.g.

Mon. 6/20/2005


Harry

I would like to group a series of recurring tasks by the following
Dtae and time grouping structure
Group BY --- 'Start Date'
Then BY --- 'Start Time'

I want to show the date and time in the start finish date columns.
Does anyone know how this can be done. Thanks.

Harry

have a Text field use the following formula:
ProjDateConv([Start],pjDate_hh_mmAM)

This will show just the time from the Start field

Then do another one with this formula in it:
ProjDateConv([Start],pjDate_mm_dd_yy)

This will show just the date.

Then do your grouping by these two fields.

 

[Harry]

Brian,
Thanks.. How can I add a Day before the date in the fomula e.g.

Mon. 6/20/2005

Also. When I sort by date and time in sequence order the start times do not
appear to be in sequence.. The later start times appear before the earlier
start times in a particular date.

e.g. 1:00 PM appear before 9:00 AM. Can you please explain what I am
doingwrong. Thanks.

Harry

Harry

I would like to group a series of recurring tasks by the following
Dtae and time grouping structure
Group BY --- 'Start Date'
Then BY --- 'Start Time'

I want to show the date and time in the start finish date columns.
Does anyone know how this can be done. Thanks.

Harry

have a Text field use the following formula:
ProjDateConv([Start],pjDate_hh_mmAM)

This will show just the time from the Start field

Then do another one with this formula in it:
ProjDateConv([Start],pjDate_mm_dd_yy)

This will show just the date.

Then do your grouping by these two fields.