Leather Knight Posted February 7, 2006 Posted February 7, 2006 I have 2 fields 1) Date 2) Quarter I need the "Quarter" field to reflect the quarter of the date field. Any advice?
Leather Knight Posted February 7, 2006 Author Posted February 7, 2006 It keeps coming up "1st Quarter 0001" no matter the date change.
Lee Smith Posted February 7, 2006 Posted February 7, 2006 The calculation works for me, are you sure the date field is a "date" type filed? The calculation for 2/6/2006 returns 1 HTH Lee
comment Posted February 7, 2006 Posted February 7, 2006 It keeps coming up "1st Quarter 0001" no matter the date change. The result indicates that the referenced Date field is empty (and that the calculation is set to evaluate when all referenced fields are empty).
Leather Knight Posted February 7, 2006 Author Posted February 7, 2006 ...Nope. I have it set for date format, do not evaluate when reference fields are empty, date field is active with data.
comment Posted February 7, 2006 Posted February 7, 2006 Well, we could sit here and keep guessing what might be wrong, or you could attach your file...
bruceR Posted February 7, 2006 Posted February 7, 2006 It keeps coming up "1st Quarter 0001" no matter the date change. Sounds like you've set it as a date field instead of number field result.
comment Posted February 7, 2006 Posted February 7, 2006 Yes, that makes sense - and also raises the question why not format the Date field itself to display as "Nth Quarter XXXX" and be done?
Leather Knight Posted February 8, 2006 Author Posted February 8, 2006 (edited) I have tried all of that. Never get "1st quarter 2005" Since the zip is 2.5 megs and too large for uploading here. Here is the link. Link It is on the "State Mileage" form. Access thru the Master Navigator. Any help is appreciated. Edited February 8, 2006 by Guest
comment Posted February 8, 2006 Posted February 8, 2006 You are not supposed to get "1st quarter 2005". You are supposed to get either 1 or 2 or 3 or 4. You will, if you set the result of the calculation to Number. If all you want is to display "1st quarter 2005", then duplicate the Date field on the layout, go to Format > Date..., select Custom and format it the same way you have formatted the Quarter field. You can then delete the Quarter field from your file - it's not needed.
Lee Smith Posted February 8, 2006 Posted February 8, 2006 Change the Field Type to NUMBER Go into layout mode and reformat the number as General, currently it is formated as dollars. Lee
Recommended Posts
This topic is 6927 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now