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