Dates

[Sez12]

Hi Team, 

I have a graph showing 22/23 FY data.

The graph date references Monday's as the start of the week. 

The 1/07 is a Friday so represented on my graph as the 27/06 however, the directors would like the date to show 1/07. 

Is there an expression I can put in that changes the 27/06 to show as the 1/07? 

Thanks for your help

[justISO]

Hi, maybe something like this:

=if([your_date_field]='27/06/22', date('01/07/22'), [your_date_field])