G
Guest
I would like to extract the financial year quarter from a Date.
I am using the DatePart("q",[date]) method on the field.
When I have a date = 01.04.05 the function returns = 2. But in reality the
financial quarter is = 1.
Is their a way I can adapt the datePart() method, OR is their a specific
method to produce this result.
Any help will be greatly appreciated. I have to produce a high level
financial report by lunch time today )
I am using the DatePart("q",[date]) method on the field.
When I have a date = 01.04.05 the function returns = 2. But in reality the
financial quarter is = 1.
Is their a way I can adapt the datePart() method, OR is their a specific
method to produce this result.
Any help will be greatly appreciated. I have to produce a high level
financial report by lunch time today )