Date Field Format - How to change

Mal,

After a little bit of head scratching I think this may work for you.

Format([Start],"\Q" & "q/yyyy")
or
Format([Start],"\Quarter" & "q/yyyy")

Regards,

Darren

Mal,

I’m not sure, the initial problem you’ll get is any time you include a ‘q’ in that formula it gets supplanted with the number that references the Quarter so you’ll end up with something like 2uarter2/2009 or 22/2009

If I get a chance this afternoon I’ll see if I can have a look.

Regards,

Darren

Hi Mal,

You could try a couple of custom formulae in your text fields. I’ll use Text1 and Text2 in this example, you can then adapt it and use whatever text fields you have available.

Text1 will be your new Start column so rename it Start and use this custom formula:
Format([Start],"mmm/yyyy")

Text2 will be your new Finish column so rename it Finish use this custom formula:
Format([Finish],"mmm/yyyy")

To show Quarters substitute mmm for q

You can then modify the table you use for your reports to show Text1 instead of Start and Text2 instead of Finish.

EDIT: Just remembered you can’t name Text fields Start or Finish so use something else that’s appropriate.

Regards,

Darren