The between operator is used to indicate that avaluefalls within a specified range. It specifies that the testvalueis greater than or equal to Value 1 and less than or equal to Value2.
This statement selects MEMBERS records that have avaluebetween0 and 499 (inclusive) in the TOTAL DUE field.
See Also
On the forum about between
Function year - differences between 6.52 - 8
I notice that the funcion Year(current date) works in different way in dataease 8. (or post 6.52) I mean if I try to run this DQLmessage year (current date) window.In dataease 8</str...
Product: Dataease [{8}]FIVE. Written by Marco Marchesi 11/03/14 at 09:41:46
Re:Function year - differences between 6.52 - 8
Marco,Easy way around this : message lastc (current date,2) window.Using lastc as above instead of year will pull the last 2 characters from the date field.Incidently I can't get year(field) ina DQL t...
Product: Dataease [{8}]FIVE. Written by Simon B 12/03/14 at 12:38:06
Got some time to sit down to look at this example. Can't say much more than wow! ... Simple small scripts doing some clever stuff here, ans showing how to use functions to do the type of thing I'm looking for.Also showing off other things...
Product: Dataease [{8}]FIVE. Written by Simon B 23/03/15 at 12:13:11
We are glad that you are getting a glimpse of the sunny side of the DE8 coin.It is the biggest challenge for DE8 that it is deceptively similar to previous versions of DFW, when in reality it is a completely different beast altogether.<b...
Product: Dataease [{8}]FIVE. Written by DataEase 25/03/15 at 14:21:47
Problem changing between Extended and Standard date
I have a date field which I set to Extended but decided after testing a couple of records to change it to Standard, however, when I click the Standard radio button all that happens is the definition window goes blank, if I then click the Typ...
Product: Dataease [{8}]FIVE. Written by Rob Birney 01/03/16 at 12:51:36
Re:Problem changing between Extended and Standard date
There is only one word for this....BUG!The field definition dialogue is unnecessarily over-engineered and as result there is some peculiar behaviour (try to switch to and from Lookup field etc).This problem has been trace...
Product: Dataease [{8}]FIVE. Written by DataEase 01/03/16 at 13:51:00
Searching date between in form when date is text 8
Hello,I have another problem, I cant find solution for that, no solution found on forum too.I have 5 fields ( text 8 each) that contain a date dd/mm/yy. I need to search records in a form, that match DateFirst to DateEnd in each of the...
Product: Dataease [{8}]FIVE. Written by HONVAULT PATRICK 14/03/19 at 13:47:50
Re:Searching date between in form when date is text 8
Hi PatrickNot sure if I understood correctly....You can try to search in a form as follow:Select Records In the field enter: between date to dateClick Select Record or Next / PreviousKind regardsJo...
Product: Dataease [{8}]FIVE. Written by Josef Vella 14/03/19 at 18:26:08
Re:Re:Searching date between in form when date is text 8
Hello Josef,Between match in text field like between "12/03/19" to "15/03/19" as > "12/03/19" or < "16/03/19"Ok , but if i want to search a between on the 5 text field simultaneously, i don't know how to do ....Thanks<...
Product: Dataease [{8}]FIVE. Written by Honvault Patrick 15/03/19 at 12:04:34
Re:Searching date between in form when date is text 8
Donwload Sample
I guess this should teach you all a lesson.
Put a boring and "...
Product: Dataease [{8}]FIVE. Written by DataEase 15/03/19 at 12:45:21
Re:Re:Searching date between in form when date is text 8
Thanks so much for all guys ! :)After convert all the 7 text fields in date, impossible to use the table, lot of error messages. After 16 hours of unsuccessful attempts, no way out, i had to recreate at 100% this table ( ... ) and tr...
Product: Dataease [{8}]FIVE. Written by Honvault Patrick 20/03/19 at 18:29:15
Re:Re:Re:Searching date between in form when date is text 8
Problem when converting from Text to Date is formatting in derivations.Dates in DataEase is writtine directly like 03/04/19 while a date in a text field would be "03/04/19".So when converting from text to date you need to change all th...
Product: Dataease [{8}]FIVE. Written by DataEase 03/04/19 at 14:32:04
On the blog about between
New Function in 8 - StringBetween() - Cut out the string between to search values. (Ver. 8.0.0.1201)
This function is the last of a triumvirate consisting of StringTo(), StringFrom() and now StringBetween().Between them they will be able to chop up any string exactly like you want it.StringBetween is like and XOR of the two other o...
Product: Dataease [{8}]FIVE. Written by DataEase 16/01/13 at 14:32:16
DataEase 8 Beauty - StingToFromBetween at work.
Everything is easy when you have your own team of developers and can just tell them which functions you want them to make. I happen to have that, so to me everything is easy....not so!Every time we make a new function we always evaluate if thi...
Product: Dataease [{8}]FIVE. Written by DataEase 20/01/13 at 15:46:22
DataEase 8 New Function - MemoStringBetween() - Copies the outer between from a Memo to another Memo (Ver. 8.0.0.1205)
Six man all! As we said in the army.The last of the Memo(String(To,From,Between)) functions are now finalised. You can now decompile any String or Memo in minute and exact detail. MemoStringBetween() copies the...
Product: Dataease [{8}]FIVE. Written by DataEase 22/01/13 at 13:56:17
Important Fix in 8 - Table Already exist and mismatch between form and table (Ver. 8.0.0.1364)
DataEase 8 development has branched out.
Up till now we have solely focused on adding new functionality to 8 and bug fixing has only been done when related to new functionality or old functionality impacted/used/involved in new functiona...
Product: Dataease [{8}]FIVE. Written by DataEase 20/08/13 at 16:33:08
Download Sample
Seeing is believing, so please find attached a sample that showcase what you are looking for.
In this sample we...
Product: Dataease [{8}]FIVE. Written by DataEase 20/03/15 at 10:47:00
DataEase 8.5.2364 - jsBridge between WebFields and PRISM added to enable WebForms
WebFields was one of the earliest features added to DataEase 8 and they have been a great additions.As everything else the more you integrate and use them the more yo...
Product: Dataease [{8}]FIVE. Written by DataEase 16/07/16 at 05:14:01
