stefanshotton Posted March 28, 2006 Posted March 28, 2006 I need to know is there a way that ican force a user to enter a strict 8 digit date field ie. DD/MM/YYYY. I have to export data to other programs that use a strict 2 digit date and 2 digit month field so would be very useful.
comment Posted March 28, 2006 Posted March 28, 2006 You shouldn't be forcing your users to enter anything beyond what Filemaker considers a valid date entry. If you need to export your dates as dd/mm/yyyy, make a calculation field (result is text) = Right ( "00" & Day ( Datefield ) ; 2 ) & "/" & Right ( "00" & Month ( Datefield ) ; 2 ) & "/" & Year ( Datefield ) and export that instead.
Recommended Posts
This topic is 6877 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