Submitted by Cyganet on 2022/02/07 08:15

Hi everyone,

When I use a grid's Group-By Bar and drag a date column to it (Due, with no specified date format), it groups items per month, so the groups are named 2022-01, 2022-02, etc.

How do I specify that I want the items grouped by day, so 2022-02-01, 2022-02-02, 2022-02-03, etc?

Thank you!

Comments

Hi Cyganet,

You can't group by day currently using the Group-by bar

You can however do the same using pivot tables, either the one built into IQ or using ODC MS Office links to Excel

p.s. You can of course also sort by date and lastly, you could create a calculated field and group by that field

Hi John,

 

Yes, I did do that. It took me a while to get the syntax right, because it's VBScript not VBA.  If anyone is interested, here is what it looks like:

A,M:[DoneLog]=Year([DoneDate])&"-"&Right(("0"&Month([DoneDate])),2)&
"-"&Right(("0"&Day([DoneDate])),2)&" "&WeekdayName(Weekday([DoneDate]))|E:[DoneLog]=

[DoneDate] is the date field, and [DoneLog] is the text field.

How do I ?