https://www.machform.com/forums/ MachForm Community Forums Topic: Logic Builder condition for date field relative to current date en Sun, 03 May 2026 23:05:41 +0000 https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17673 Sun, 17 Mar 2013 00:49:29 +0000 jrmedia 17673@https://www.machform.com/forums/ <p>This is a great idea for something such as an "age of majority" checker, to have the person enter their date of birth and display additional information (such as parent/guardian information).</p> <p>I'm looking at this thread and the code makes no sense to me (I'm a designer, not a developer).</p> <p>What do I need to do to implement the fix shown here? </p> https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17362 Fri, 22 Feb 2013 11:24:18 +0000 yuniar 17362@https://www.machform.com/forums/ <p>awesome! :-) </p> https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17342 Thu, 21 Feb 2013 05:36:04 +0000 timcov 17342@https://www.machform.com/forums/ <p>Many Thanks Yuniar - it works. For anyone that needs it the sql query I used to reset the day in the condition to "the day after tomorrow" was:</p> <p>$sql = "UPDATE <code>my_dbase_name</code>.<code>ap_field_logic_conditions</code> SET <code>rule_keyword</code> = DATE_ADD(CURRENT_DATE(),INTERVAL 2 DAY) WHERE <code>form_id</code> =12345 AND <code>rule_condition</code> = 'is_before'";</p> <p>MySql Event Scheduler would be a better way to run it regularly but my shared hosting doesn't seem to allow me to enable it. </p> https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17314 Tue, 19 Feb 2013 19:02:06 +0000 yuniar 17314@https://www.machform.com/forums/ <p>If you are familiar with cron job, then yes option B would be the safest and cleanest, because it won't affect any other functionality. Simply update the "rule_keyword" column on "ap_field_logic_conditions" table. </p> https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17299 Mon, 18 Feb 2013 23:23:03 +0000 timcov 17299@https://www.machform.com/forums/ <p>Thank you for the prompt response<br /> However needing to overcome this for a particular application and not wishing to give up - is it worth my while either:<br /> a) looking for the php code that applies the rule and trying to "hard code" that rule instead? or<br /> b) create a cronjob to run a linux job on my hosting each morning that takes today's date, adds 1 to it and then updates the rule in the MySQL table: ap_field_logic_conditions accordingly?</p> <p>I appreciate both would be crude solutions but I'm reluctant to ask the administrator to login each morning and change the rule to tomorrows date.</p> <p>Option b) is perhaps safest as I only follow enough about php coding to find relevant sections of existing code and make simple tweaks. At least with b) I'm only trying to update one field in one record of the database with a text format of the system date and am not trying to change the code itself?</p> <p>Thanks Again </p> https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17292 Mon, 18 Feb 2013 21:15:23 +0000 yuniar 17292@https://www.machform.com/forums/ <p>Hi timcov,</p> <p>Unfortunately it won't be possible to set relative date as part of the rule. Sorry :(<br /> Thank you for your feedback on this though. It's a very good idea. </p> https://www.machform.com/forums/topic/logic-builder-condition-for-date-field-relative-to-current-date#post-17279 Mon, 18 Feb 2013 08:48:53 +0000 timcov 17279@https://www.machform.com/forums/ <p>I very new to the MachForm but it is fantastic. I can't believe I've been wasting so much time messing with the hosted solutions such as the numerous online survey builders etc. Complete control over the data at last!<br /> Anyhow quick question - I can set the default for a date field for "tomorrow" or "+2 days" (surprisingly simple) but that doesn't work in the logic builder which seems to need specific dates. Is there a notation to use to achieve skipping a page unless the value of a date field is tomorrow for example?<br /> Thanks for a great product. </p>