How to update date format in valueformat in Text Mode Grouping of a Task Report?

[Rasheedah_]

Is it possible to update the date format that is shown in a grouping of a report (specifically task report)? I attempted updating the group.0.valueformat  to the partialAtDate format, but the grouping would just show no value for the groupings once saved. The field I am pulling from is a custom field at the project level of the tasks the report is pulling in.

This is the grouping Text Mode I tried:

textmode=true
group.0.groupdatesby=DY
group.0.namekeyargkey.0=project
group.0.namekeyargkey.1=targetLaunchDate
group.0.notime=false
group.0.valuefield=project:targetLaunchDate
group.0.iscollapsed=true
group.0.valueformat=partialAtDate
group.0.namekey=view.relatedcolumn
group.0.linkedname=project

This is the original Text Mode for the grouping:

textmode=true
group.0.linkedname=project
group.0.namekey=view.relatedcolumn
group.0.valuefield=project:targetLaunchDate
group.0.namekeyargkey.0=project
group.0.namekeyargkey.1=targetLaunchDate
group.0.iscollapsed=true
group.0.notime=false
group.0.groupdatesby=DY
group.0.valueformat=customDateAsDayString

[TealeMc4]

Hi Rasheedah, 

It sounds like your custom field may not be a Date field. I've tried several ways to see if anything works to convert a text field to a date and can't find one. 

If that's the case, I suggest creating a calculated custom field to capture the date from your custom Target Launch Date field and group your report by that. Otherwise, you'll need to create a new field in a date format and migrate the data so you'll be able to group by it.

Hope this helps, 

Teale

[Sven-iX]

Hi @Rasheedah_ 

A date field comes with these grouping options - switch back to "standard Mode" to see them.

looks like these are the options you'll then see in textMode

D	customDateAsDayOfYearString	Day of Year
DY	customDateAsDayString	Day
W	customDateAsWeekOfYearString	Week of Year
WY	customDateAsWeekString	Week
M	customDateAsMonthOfYearString	Month of Year
MY	customDateAsMonthString	Month
Q	customDateAsQuarterOfYearString	Quarter of Year
QY	customDateAsQuarterString	Quarter
Y	customDateAsYearString	Year

[Sri_Nijs]

In text mode grouping , below should work though: 

group.0.groupdatesby=WY
group.0.valueformat=atDateAsWeekString

 or 

group.0.groupdatesby=DY
group.0.valueformat=atDateAsDayString

[Rasheedah_]

Thank you all so much for the suggestions! Unfortunately they did not provide the desired outcome.

I am just providing a bit more context in case anyone else can give any further insight:

This is currently what the date format is with the original text mode that I am using after selecting for the dates to be grouped by day in the standard view.

This is an example of the desired date format of the grouping, but grouped by day - not week:

When replacing the corresponding line values with the below suggestions, it displays as no value.

group.0.groupdatesby=DY
group.0.valueformat=atDateAsDayString

The custom field I am grouping by is a date field that is housed at the project level. The report is pulling in tasks.

[Sven-iX]

Hi @Rasheedah_ 

have you tried a valueexpression in the grouping? 

It looks like the canned displayFormats won't solve your need. You could use this value expression (that basically manually puts together the date in the form you want) 

textmode=true
group.0.valueexpression="Target Launch Date: "+case(month({DE:targetLaunchDate}), "Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")+" "+dayofmonth({DE:targetLaunchDate})+", "+year({DE:targetLaunchDate})
group.0.valueformat=HTML