Date Field Format - How to change
Featured Partner
Top Posters
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts
Our Partners
Darren
Many thanks.
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
Darren
Many thanks
Can it be set to say
Qx/yyyy
Cheers
Mal
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 cant name Text fields Start or Finish so use something else thats appropriate.
Regards,
Darren