Newbies Lee Rose Posted October 26, 2007 Newbies Share Posted October 26, 2007 Pretty new guy here trying to update a Filemaker application that my developer has had to drop. I have a date field with a pop-up of the calendar but I'm trying to get that date to fill in a "day of the week" i.e. Monday, Tuesday, Wednesday in another "text" field. Anyone have any ideas? The only thing I know is the date format function in Excel but there doesn't seem to be any similar function in Filemaker. Could it be a "lookup" based on a value list of the days of the week? Link to comment Share on other sites More sharing options...
Lee Smith Posted October 26, 2007 Share Posted October 26, 2007 Your question really can be read a couple of ways. So, to clarify: Are you wanting the field to show, based on the Calendar day choosen, Monday, Oct 22, 2007 Or Monday Or are you just wanting to select the text of name from a list of names like this Monday Tuesday Wendnesday Thrusday Friday, etc. and when they choose one of these, the field will contain the selection. i.e. Monday This would [color:red]not be a date in this case. HTH Lee Link to comment Share on other sites More sharing options...
comment Posted October 26, 2007 Share Posted October 26, 2007 The function is DayOfWeek(). You can also place another instance of the date field on the same layout and format it to display the day of the week - alone or in combination with other parameters. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6119 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