Re: [WebDNA] Dead line Time Math

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113516
interpreted = N
texte = 1111 --Apple-Mail=_0E18140D-8925-44BC-A479-380BD7B34F60 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 These have all been good examples. Here's another using a slightly = different twist- comparing a virtual decimal number. =20 [if = [math]{[date]}[/math].[math]{[time]}[/math]>[math]{03/30/2017}[/math].[mat= h]{17:00:00}[/math]] [then]Not for you[/then] [else]Registration still open[/else] [/if] MD > On Mar 27, 2017, at 6:37 PM, Terry Nair wrote: >=20 > Oops sorry =E2=80=A6one too many maths [ =E2=80=A6 ] when trying to = adapt the example for you =E2=80=A6should be like this =E2=80=A6. > =20 > [!] > [/!][text show=3DF]todaydate=3D[math]{[date]}[/math][/text][!] > [/!][text show=3DF]todaytime=3D[math]{[time]}[/math][/text][!] > [/!][text show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!] > [/!][text show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!] > [/!][if = [math]([expiredate]*86400)+[expiretime][/math]>[math]([todaydate]*86400)+[= todaytime][/math]][then][!] > [/!]Here's the registration form ...[!] > [/!][/then][else][!] > [/!]Sorry, registration closed[!] > [/!][/else][/if][!] > [/!] > =20 > Cheers TDn > =20 > =20 > =20 > From: Terry Nair [mailto:terrynair@prism4u.com = ]=20 > Sent: Tuesday, March 28, 2017 09:27 > To: talk@webdna.us > Subject: RE: [WebDNA] Dead line Time Math > =20 > Or something like this =E2=80=A6.. > =20 > [!] > [/!][text show=3DF]todaydate=3D[math]{[date]}[/math][/text][!] > [/!][text show=3DF]todaytime=3D[math]{[time]}[/math][/text][!] > [/!][text show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!] > [/!][text show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!] > [/!][if = [math]([math]{[expiredate]}[/math]*86400)+[math]{[expiretime]}[/math][/mat= h]>[math]([todaydate]*86400)+[todaytime][/math]][then][!] > [/!]Here's the registration form ...[!] > [/!][/then][else][!] > [/!]Sorry, registration closed[!] > [/!][/else][/if][!] > [/!] > =20 > Cheers TDn > =20 > From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 > Sent: Tuesday, March 28, 2017 06:40 > To: WebDNA Talk List > Subject: Re: [WebDNA] Dead line Time Math > =20 > A real life example using real dates and time will help you to see = what is happening, note that BOTH comparisons must be true to get a THEN = result because we are using & in the IF. > =20 > CLOSINGDATE=3D03/30/2017 > CLOSINGTIME=3D17:00:00 > =20 > So closing time is 5pm on 30th March 2017 > =20 > =20 > We are doing: IF (part a & part b) OR (part c & part d) because we = also need to calculate for the DAY of closing. > =20 > [IF = ((03/28/2017>03/30/2017)&(09:00:00>17:00:00))|((03/28/2017=3D03/30/2017)&(= 09:00:00>17:00:00))] > [THEN]Sorry, registration closed.[/THEN] > [ELSE]Here's the registration form ...[/ELSE] <<< This is = the result > [/IF] > =20 > =20 > [IF = ((03/30/2017>03/30/2017)&(09:00:00>17:00:00))|((03/30/2017=3D03/30/2017)&(= 09:00:00>17:00:00))] > [THEN]Sorry, registration closed.[/THEN] > [ELSE]Here's the registration form ...[/ELSE] <<< This is = the result > [/IF] > =20 > =20 > [IF = ((03/30/2017>03/30/2017)&(17:00:01>17:00:00))|((03/30/2017=3D03/30/2017)&(= 17:00:01>17:00:00))] > [THEN]Sorry, registration closed.[/THEN] <<< This is the = result because the second part of IF is true > [ELSE]Here's the registration form ...[/ELSE]=20 > [/IF] > =20 > =20 > =20 > =20 > =20 > Kind regards > =20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au > =20 > =20 > =20 > =20 >=20 > =20 >> On 28 Mar 2017, at 09:34, Stuart Tremain > wrote: >> =20 >> Sorry, I did not take into account that we also need a date =3D >> =20 >> Give me a few minutes. >> =20 >> =20 >> Kind regards >> =20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >> =20 >> =20 >> =20 >> =20 >>=20 >> =20 >>> On 28 Mar 2017, at 09:23, Lawrence Banahan > wrote: >>> =20 >>> This only works if {[TIMENOW}>{[CLOSINGTIME} >>> if you connect in the morning timenow is 9am and closing time 12am = this comparaison doesn't work. It works only in the morning. >>> Am I right? >>> =20 >>> 2017-03-28 0:05 GMT+02:00 Stuart Tremain >: >>> [IF = ([MATH]{[TODAYSDATE}[/MATH]>[MATH]{[CLOSINGDATEDATE}[/MATH])&([MATH]{[TIME= NOW}[/MATH]>[MATH]{[CLOSINGTIME}[/MATH])] >>> [THEN]Sorry, registration closed.[/THEN] >>> [ELSE]Here's the registration form ...[/ELSE] >>> [/IF] >>> =20 >>> =20 >>> =20 >>> =20 >>> Kind regards >>> =20 >>> Stuart Tremain >>> Pharoah Lane Software >>> AUSTRALIA >>> webdna@idfk.com.au >>> =20 >>> =20 >>> =20 >>> =20 >>>=20 >>> =20 >>>> On 28 Mar 2017, at 08:38, Lawrence Banahan > wrote: >>>> =20 >>>> I was adding seconds to days. >>>> This can't work. >>>> Is there a way to get this work? >>>>=20 >>>> [if = [math]{[todaysdate]}+{[TodaysTIME]}[/math]>[math]{03/26/2017}+{12:00:00}[/= math]] >>>> [then]Sorry, registration closed.
[/then] >>>> [else]Here's the registration form ...
[/else] >>>> [/if] >>>>=20 >>>>=20 >>>> >>>> Kenneth Grome >>>> 27 mars 2017 22:37 >>>> I think this is what you want: >>>>=20 >>>> [if [math]{[date]}[/math]>[math]{03/26/2017}[/math]] >>>> [then]Sorry, registration closed.[/then] >>>> [else]Here's the registration form ...[/else] >>>> [/if] >>>>=20 >>>> Regards, >>>> Kenneth Grome >>>> WebDNA Solutions >>>> http://www.webdnasolutions.com >>>> Web Database Systems and Linux Server Administration >>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: = >>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>> Bug Reporting: support@webdna.us >>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>> =20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>> =20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> =20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list . To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us --Apple-Mail=_0E18140D-8925-44BC-A479-380BD7B34F60 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 These have all been good examples.  Here's another using = a slightly different twist- comparing a virtual decimal number. =  

[if = [math]{[date]}[/math].[math]{[time]}[/math]>[math]{03/30/2017}[/math].[= math]{17:00:00}[/math]]
[then]Not for = you[/then]
[else]Registration still = open[/else]
[/if]

MD


On Mar 27, 2017, at 6:37 PM, = Terry Nair <terrynair@prism4u.com> wrote:

Oops sorry =E2=80=A6one = too many maths [ =E2=80=A6 ] when trying to adapt the example for you = =E2=80=A6should be like this =E2=80=A6.
 
[!]
[/!][text = show=3DF]todaydate=3D[math]{[date]}[/math][/text][!]
[/!][text = show=3DF]todaytime=3D[math]{[time]}[/math][/text][!]
[/!][text = show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!]
[/!][text = show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!]
[/!][if = [math]([expiredate]*86400)+[expiretime][/math]>[math]([todaydate]*86400= )+[todaytime][/math]][then][!]
[/!]Here's the registration form ...[!]
[/!][/then][else][!]
[/!]Sorry, registration closed[!]
[/!][/else][/if][!]
[/!]
 
Cheers TDn
 
 
 
From: Terry Nair [mailto:terrynair@prism4u.com] 
Sent: Tuesday, March 28, 2017 = 09:27
To: talk@webdna.us
Subject: RE: [WebDNA] Dead line Time = Math
 
Or something like this = =E2=80=A6..
 
[!]
[/!][text = show=3DF]todaydate=3D[math]{[date]}[/math][/text][!]
[/!][text = show=3DF]todaytime=3D[math]{[time]}[/math][/text][!]
[/!][text = show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!]
[/!][text = show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!]
[/!][if = [math]([math]{[expiredate]}[/math]*86400)+[math]{[expiretime]}[/math][/mat= h]>[math]([todaydate]*86400)+[todaytime][/math]][then][!]
[/!]Here's the registration form ...[!]
[/!][/then][else][!]
[/!]Sorry, registration closed[!]
[/!][/else][/if][!]
[/!]
 
Cheers TDn
 
From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Tuesday, March 28, 2017 = 06:40
To: WebDNA Talk List
Subject: Re: [WebDNA] Dead line Time = Math
 
A real life example using real dates and = time will help you to see what is happening, note that BOTH comparisons = must be true to get a THEN result because we are using & in the = IF.
 
CLOSINGDATE=3D03/30/2017
CLOSINGTIME=3D17:00:00
 
So closing time is 5pm on 30th March 2017
 
 
We are doing: IF (part a & part b) OR (part c = & part d) because  we also need to calculate for the DAY of = closing.
 
[IF = ((03/28/2017>03/30/2017)&(09:00:00>17:00:00))|((03/28/2017=3D03/= 30/2017)&(09:00:00>17:00:00))]
        &= nbsp;   [THEN]Sorry, = registration closed.[/THEN]
        &= nbsp;   [ELSE]Here's the = registration form ...[/ELSE] <<< This is the result
[/IF]
 
 
[IF = ((03/30/2017>03/30/2017)&(09:00:00>17:00:00))|((03/30/2017=3D03/= 30/2017)&(09:00:00>17:00:00))]
        &= nbsp;   [THEN]Sorry, = registration closed.[/THEN]
        &= nbsp;   [ELSE]Here's the = registration form ...[/ELSE] <<< This is the result
[/IF]
 
 
[IF = ((03/30/2017>03/30/2017)&(17:00:01>17:00:00))|((03/30/2017=3D03/= 30/2017)&(17:00:01>17:00:00))]
        &= nbsp;   [THEN]Sorry, = registration closed.[/THEN]  <<< This is the result = because the second part of IF is true
        &= nbsp;   [ELSE]Here's the = registration form ...[/ELSE] 
[/IF]
 
 
 
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au
 
 
 

 

 
On 28 Mar 2017, at 09:34, Stuart Tremain <webdna@idfk.com.au> = wrote:
 
Sorry, I did not take = into account that we also need a date =3D
 
Give me a few minutes.
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au
 
 
 

 

 
On 28 Mar 2017, at 09:23, Lawrence Banahan <banahan.l@gmail.com> = wrote:
 
This only works = if {[TIMENOW}>{[CLOSINGTIME}
if you connect in = the morning timenow is 9am and closing time 12am this comparaison = doesn't work. It works only in the morning.
Am I = right?
 
2017-03-28 0:05 = GMT+02:00 Stuart Tremain <webdna@idfk.com.au>:
[IF = ([MATH]{[TODAYSDATE}[/MATH]>[MATH]{[CLOSINGDATEDATE}[/MATH])&([MATH= ]{[TIMENOW}[/MATH]>[MATH]{[CLOSINGTIME}[/MATH])]
[THEN]Sorry, registration closed.[/THEN]
[ELSE]Here's the registration form ...[/ELSE]
[/IF]
 
 
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
 
 
 

 

 
On 28 Mar 2017, at 08:38, Lawrence = Banahan <banahan.l@gmail.com> wrote:
 

I was adding seconds to days.
This can't = work.
Is there a way to get this work?

[if = [math]{[todaysdate]}+{[TodaysTIME]}[/math]>[math]{03/26/2017}+{12:00:00= }[/math]]
[then]Sorry, registration = closed.<br>[/then]
[else]Here's the registration = form ...<br>[/else]
[/if]

<image001.jpg>
Kenneth = Grome
27 mars 2017 = 22:37

I think this is what you = want:

[if = [math]{[date]}[/math]>[math]{03/26/2017}[/math]]
[then]Sorry, registration closed.[/then]
[else]Here's the registration form ...[/else]
[/if]

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database = Systems and Linux Server Administration

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.us
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . = To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail=_0E18140D-8925-44BC-A479-380BD7B34F60-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
  2. Re: [WebDNA] Dead line Time Math (Tom Duke 2017)
  3. Re: [WebDNA] Dead line Time Math (Michael Davis 2017)
  4. RE: [WebDNA] Dead line Time Math ("Terry Nair" 2017)
  5. RE: [WebDNA] Dead line Time Math ("Terry Nair" 2017)
  6. Re: [WebDNA] Dead line Time Math (Stuart Tremain 2017)
  7. Re: [WebDNA] Dead line Time Math (Stuart Tremain 2017)
  8. Re: [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
  9. Re: [WebDNA] Dead line Time Math (Stuart Tremain 2017)
  10. Re: [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
  11. Re: [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
  12. Re: [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
  13. Re: [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
  14. Re: [WebDNA] Dead line Time Math (Kenneth Grome 2017)
  15. [WebDNA] Dead line Time Math (Lawrence Banahan 2017)
1111 --Apple-Mail=_0E18140D-8925-44BC-A479-380BD7B34F60 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 These have all been good examples. Here's another using a slightly = different twist- comparing a virtual decimal number. =20 [if = [math]{[date]}[/math].[math]{[time]}[/math]>[math]{03/30/2017}[/math].[mat= h]{17:00:00}[/math]] [then]Not for you[/then] [else]Registration still open[/else] [/if] MD > On Mar 27, 2017, at 6:37 PM, Terry Nair wrote: >=20 > Oops sorry =E2=80=A6one too many maths [ =E2=80=A6 ] when trying to = adapt the example for you =E2=80=A6should be like this =E2=80=A6. > =20 > [!] > [/!][text show=3DF]todaydate=3D[math]{[date]}[/math][/text][!] > [/!][text show=3DF]todaytime=3D[math]{[time]}[/math][/text][!] > [/!][text show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!] > [/!][text show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!] > [/!][if = [math]([expiredate]*86400)+[expiretime][/math]>[math]([todaydate]*86400)+[= todaytime][/math]][then][!] > [/!]Here's the registration form ...[!] > [/!][/then][else][!] > [/!]Sorry, registration closed[!] > [/!][/else][/if][!] > [/!] > =20 > Cheers TDn > =20 > =20 > =20 > From: Terry Nair [mailto:terrynair@prism4u.com = ]=20 > Sent: Tuesday, March 28, 2017 09:27 > To: talk@webdna.us > Subject: RE: [WebDNA] Dead line Time Math > =20 > Or something like this =E2=80=A6.. > =20 > [!] > [/!][text show=3DF]todaydate=3D[math]{[date]}[/math][/text][!] > [/!][text show=3DF]todaytime=3D[math]{[time]}[/math][/text][!] > [/!][text show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!] > [/!][text show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!] > [/!][if = [math]([math]{[expiredate]}[/math]*86400)+[math]{[expiretime]}[/math][/mat= h]>[math]([todaydate]*86400)+[todaytime][/math]][then][!] > [/!]Here's the registration form ...[!] > [/!][/then][else][!] > [/!]Sorry, registration closed[!] > [/!][/else][/if][!] > [/!] > =20 > Cheers TDn > =20 > From: Stuart Tremain [mailto:webdna@idfk.com.au = ]=20 > Sent: Tuesday, March 28, 2017 06:40 > To: WebDNA Talk List > Subject: Re: [WebDNA] Dead line Time Math > =20 > A real life example using real dates and time will help you to see = what is happening, note that BOTH comparisons must be true to get a THEN = result because we are using & in the IF. > =20 > CLOSINGDATE=3D03/30/2017 > CLOSINGTIME=3D17:00:00 > =20 > So closing time is 5pm on 30th March 2017 > =20 > =20 > We are doing: IF (part a & part b) OR (part c & part d) because we = also need to calculate for the DAY of closing. > =20 > [IF = ((03/28/2017>03/30/2017)&(09:00:00>17:00:00))|((03/28/2017=3D03/30/2017)&(= 09:00:00>17:00:00))] > [THEN]Sorry, registration closed.[/THEN] > [ELSE]Here's the registration form ...[/ELSE] <<< This is = the result > [/IF] > =20 > =20 > [IF = ((03/30/2017>03/30/2017)&(09:00:00>17:00:00))|((03/30/2017=3D03/30/2017)&(= 09:00:00>17:00:00))] > [THEN]Sorry, registration closed.[/THEN] > [ELSE]Here's the registration form ...[/ELSE] <<< This is = the result > [/IF] > =20 > =20 > [IF = ((03/30/2017>03/30/2017)&(17:00:01>17:00:00))|((03/30/2017=3D03/30/2017)&(= 17:00:01>17:00:00))] > [THEN]Sorry, registration closed.[/THEN] <<< This is the = result because the second part of IF is true > [ELSE]Here's the registration form ...[/ELSE]=20 > [/IF] > =20 > =20 > =20 > =20 > =20 > Kind regards > =20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au > =20 > =20 > =20 > =20 >=20 > =20 >> On 28 Mar 2017, at 09:34, Stuart Tremain > wrote: >> =20 >> Sorry, I did not take into account that we also need a date =3D >> =20 >> Give me a few minutes. >> =20 >> =20 >> Kind regards >> =20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >> =20 >> =20 >> =20 >> =20 >>=20 >> =20 >>> On 28 Mar 2017, at 09:23, Lawrence Banahan > wrote: >>> =20 >>> This only works if {[TIMENOW}>{[CLOSINGTIME} >>> if you connect in the morning timenow is 9am and closing time 12am = this comparaison doesn't work. It works only in the morning. >>> Am I right? >>> =20 >>> 2017-03-28 0:05 GMT+02:00 Stuart Tremain >: >>> [IF = ([math]{[TODAYSDATE}[/MATH]>[math]{[CLOSINGDATEDATE}[/MATH])&([math]{[TIME= NOW}[/MATH]>[math]{[CLOSINGTIME}[/MATH])] >>> [THEN]Sorry, registration closed.[/THEN] >>> [ELSE]Here's the registration form ...[/ELSE] >>> [/IF] >>> =20 >>> =20 >>> =20 >>> =20 >>> Kind regards >>> =20 >>> Stuart Tremain >>> Pharoah Lane Software >>> AUSTRALIA >>> webdna@idfk.com.au >>> =20 >>> =20 >>> =20 >>> =20 >>>=20 >>> =20 >>>> On 28 Mar 2017, at 08:38, Lawrence Banahan > wrote: >>>> =20 >>>> I was adding seconds to days. >>>> This can't work. >>>> Is there a way to get this work? >>>>=20 >>>> [if = [math]{[todaysdate]}+{[TodaysTIME]}[/math]>[math]{03/26/2017}+{12:00:00}[/= math]] >>>> [then]Sorry, registration closed.
[/then] >>>> [else]Here's the registration form ...
[/else] >>>> [/if] >>>>=20 >>>>=20 >>>> >>>> Kenneth Grome >>>> 27 mars 2017 22:37 >>>> I think this is what you want: >>>>=20 >>>> [if [math]{[date]}[/math]>[math]{03/26/2017}[/math]] >>>> [then]Sorry, registration closed.[/then] >>>> [else]Here's the registration form ...[/else] >>>> [/if] >>>>=20 >>>> Regards, >>>> Kenneth Grome >>>> WebDNA Solutions >>>> http://www.webdnasolutions.com >>>> Web Database Systems and Linux Server Administration >>>>=20 >>>> --------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: = >>>> archives: http://mail.webdna.us/list/talk@webdna.us = >>>> Bug Reporting: support@webdna.us >>>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>> =20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >>> =20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us >> =20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list . = To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us = ------------------------------------------------= --------- This message is sent to you because you are subscribed to the = mailing list . To unsubscribe, E-mail to: archives: = http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: = support@webdna.us --Apple-Mail=_0E18140D-8925-44BC-A479-380BD7B34F60 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 These have all been good examples.  Here's another using = a slightly different twist- comparing a virtual decimal number. =  

[if = [math]{[date]}[/math].[math]{[time]}[/math]>[math]{03/30/2017}[/math].[= math]{17:00:00}[/math]]
[then]Not for = you[/then]
[else]Registration still = open[/else]
[/if]

MD


On Mar 27, 2017, at 6:37 PM, = Terry Nair <terrynair@prism4u.com> wrote:

Oops sorry =E2=80=A6one = too many maths [ =E2=80=A6 ] when trying to adapt the example for you = =E2=80=A6should be like this =E2=80=A6.
 
[!]
[/!][text = show=3DF]todaydate=3D[math]{[date]}[/math][/text][!]
[/!][text = show=3DF]todaytime=3D[math]{[time]}[/math][/text][!]
[/!][text = show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!]
[/!][text = show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!]
[/!][if = [math]([expiredate]*86400)+[expiretime][/math]>[math]([todaydate]*86400= )+[todaytime][/math]][then][!]
[/!]Here's the registration form ...[!]
[/!][/then][else][!]
[/!]Sorry, registration closed[!]
[/!][/else][/if][!]
[/!]
 
Cheers TDn
 
 
 
From: Terry Nair [mailto:terrynair@prism4u.com] 
Sent: Tuesday, March 28, 2017 = 09:27
To: talk@webdna.us
Subject: RE: [WebDNA] Dead line Time = Math
 
Or something like this = =E2=80=A6..
 
[/!][text = show=3DF]todaydate=3D[math]{[date]}[/math][/text][!]
[/!][text = show=3DF]todaytime=3D[math]{[time]}[/math][/text][!]
[/!][text = show=3DF]expiredate=3D[math]{03/30/2017}[/math][/text][!]
[/!][text = show=3DF]expiretime=3D[math]{17:00:00}[/math][/text][!]
[/!][if = [math]([math]{[expiredate]}[/math]*86400)+[math]{[expiretime]}[/math][/mat= h]>[math]([todaydate]*86400)+[todaytime][/math]][then][!]
[/!]Here's the registration form ...[!]
[/!][/then][else][!]
[/!]Sorry, registration closed[!]
[/!][/else][/if][!]
[/!]
 
Cheers TDn
 
From: Stuart Tremain [mailto:webdna@idfk.com.au] 
Sent: Tuesday, March 28, 2017 = 06:40
To: WebDNA Talk List
Subject: Re: [WebDNA] Dead line Time = Math
 
A real life example using real dates and = time will help you to see what is happening, note that BOTH comparisons = must be true to get a THEN result because we are using & in the = IF.
 
CLOSINGDATE=3D03/30/2017
CLOSINGTIME=3D17:00:00
 
So closing time is 5pm on 30th March 2017
 
 
We are doing: IF (part a & part b) OR (part c = & part d) because  we also need to calculate for the DAY of = closing.
 
[IF = ((03/28/2017>03/30/2017)&(09:00:00>17:00:00))|((03/28/2017=3D03/= 30/2017)&(09:00:00>17:00:00))]
        &= nbsp;   [THEN]Sorry, = registration closed.[/THEN]
        &= nbsp;   [ELSE]Here's the = registration form ...[/ELSE] <<< This is the result
[/IF]
 
 
[IF = ((03/30/2017>03/30/2017)&(09:00:00>17:00:00))|((03/30/2017=3D03/= 30/2017)&(09:00:00>17:00:00))]
        &= nbsp;   [THEN]Sorry, = registration closed.[/THEN]
        &= nbsp;   [ELSE]Here's the = registration form ...[/ELSE] <<< This is the result
[/IF]
 
 
[IF = ((03/30/2017>03/30/2017)&(17:00:01>17:00:00))|((03/30/2017=3D03/= 30/2017)&(17:00:01>17:00:00))]
        &= nbsp;   [THEN]Sorry, = registration closed.[/THEN]  <<< This is the result = because the second part of IF is true
        &= nbsp;   [ELSE]Here's the = registration form ...[/ELSE] 
[/IF]
 
 
 
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au
 
 
 

 

 
On 28 Mar 2017, at 09:34, Stuart Tremain <webdna@idfk.com.au> = wrote:
 
Sorry, I did not take = into account that we also need a date =3D
 
Give me a few minutes.
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au
 
 
 

 

 
On 28 Mar 2017, at 09:23, Lawrence Banahan <banahan.l@gmail.com> = wrote:
 
This only works = if {[TIMENOW}>{[CLOSINGTIME}
if you connect in = the morning timenow is 9am and closing time 12am this comparaison = doesn't work. It works only in the morning.
Am I = right?
 
2017-03-28 0:05 = GMT+02:00 Stuart Tremain <webdna@idfk.com.au>:
[IF = ([math]{[TODAYSDATE}[/MATH]>[math]{[CLOSINGDATEDATE}[/MATH])&([MATH= ]{[TIMENOW}[/MATH]>[math]{[CLOSINGTIME}[/MATH])]
[THEN]Sorry, registration closed.[/THEN]
[ELSE]Here's the registration form ...[/ELSE]
[/IF]
 
 
 
 
Kind regards
 
Stuart Tremain
Pharoah Lane Software
AUSTRALIA
 
 
 

 

 
On 28 Mar 2017, at 08:38, Lawrence = Banahan <banahan.l@gmail.com> wrote:
 

I was adding seconds to days.
This can't = work.
Is there a way to get this work?

[if = [math]{[todaysdate]}+{[TodaysTIME]}[/math]>[math]{03/26/2017}+{12:00:00= }[/math]]
[then]Sorry, registration = closed.<br>[/then]
[else]Here's the registration = form ...<br>[/else]
[/if]

<image001.jpg>
Kenneth = Grome
27 mars 2017 = 22:37

I think this is what you = want:

[if = [math]{[date]}[/math]>[math]{03/26/2017}[/math]]
[then]Sorry, registration closed.[/then]
[else]Here's the registration form ...[/else]
[/if]

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database = Systems and Linux Server Administration

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.us
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
 
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us
--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . = To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --Apple-Mail=_0E18140D-8925-44BC-A479-380BD7B34F60-- . Michael Davis

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Now you see it now you donīt (1997) Need help with [cart] (2000) Bug or syntax error on my part? (1997) Table sorting by selected category then others (2004) Webcat2, WebCommerce, Mod 10 etc. (1997) send mail problem? (1997) OT - royalty free images (2002) Requiring that certain fields be completed (1997) Interfacing WC with mail server (1998) Authorize.net (2001) Calendar (1997) Universal root for WC errors? (1997) [append] and SSL (1997) Commitdatabase tag (1998) Emailer Problem (1999) writefile - continued (1997) WebMerchant Error (1998) Umm...about those log files? (Off Topic) (1997) calculating tax rates, mail order solutions and version 2 (1997) negative less than (2000)