FM6 need to ensure date format

General support questions.
Posts: 58
Joined: Tue Jul 26, 2005 12:08 pm
Location: London
PostPosted: Tue Mar 14, 2006 8:20 am
I have a database that requires the user to enter dates as the first of each month.

I want to set up a warning that alerts the user if they have not used the date format (UK date) 1/mm/yyyy.

I cannot see a date function in FM6 to check that this is the case. I have tried a text function to extract the first Left character but this does not seem to be the way to do it.

Sorry if this is obvious but I am stuck!

Thanks as always.

David
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Tue Mar 14, 2006 9:00 am
Assuming they are entering a date field (not a text field) the following will evaluate true if they enter the first of the month:

Date ( month ( datefield ) ; 1 ; year ( datefield ) ) = datefield
John Sindelar
SeedCode
Posts: 58
Joined: Tue Jul 26, 2005 12:08 pm
Location: London
PostPosted: Wed Mar 15, 2006 6:44 am
Thank you John, as always.

Best regards

David

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: