csmedsrc Posted March 31, 2009 Posted March 31, 2009 I am new to File Maker and can't figure this out. I have a date field called WeekStarting that is a dropdown calendar where the user chooses the week beginning on a Monday. I want to calculate the dates for Tues, Wed, etc. and display them. I tried using this calculation for figuring out the date on Tuesday, but it's not working. Date(Month(WeekStarting); Day(WeekStarting)+1; Year(WeekStarting))
comment Posted March 31, 2009 Posted March 31, 2009 If WeekStarting is Monday, then Tuesday is = WeekStarting + 1 Make sure that WeekStarting is a Date field, and that the result of the calculation is set to type Date. Your formula, albeit more laborious, should work too - what results are you getting?
csmedsrc Posted March 31, 2009 Author Posted March 31, 2009 I was getting a strange string of numbers. The reasons was that I did not have the calculation result set to date. Thanks for the help.
Recommended Posts
This topic is 6056 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