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:

Huge databases and RAM (1998) Smith Micro - no competition (2000) Shipping charges depending on tax rate? (1997) WCS Newbie question (1997) M$loth messes with our sites (again) (2004) expired beta (1997) getchars broken? (1997) unable to launch acgi in WebCat (1997) DOS variable bug (was SandBox and ImageMagick) (2003) all records returned. (1997) [WebDNA] Anyone using WebDNA7 and Lion Server? (2011) [WebDNA] WebDNA Health Monitor (2014) For those of you not on the WebCatalog Beta... (1997) popups, netscape vs explorer (1997) RE: [WebDNA] .htm files (2008) Date search - yes or no (1997) Problem with Shared POP script (2003) Domain name & WebDNA 5.0 (2003) PIXO support (1997) WC2b12: Yes, Formulas.db is for real (1997)