Karen is correct, LabelsPrintedDTS is DateTime cuz we want to know when
the labels were printed.
Assigning 0 or 1 is what the Boolean calculated column is doing
automatically.
The question about when calculated columns are evaluated remains.
Doug
Go Packers
On 6/18/2025 3:41 PM, 'Karen Tellef' via RBASE-L wrote:
Nick: His LabelsPrintedDTS field is a DATETIME or DATE, as far as I
can tell
Karen
On Wednesday, June 18, 2025 at 03:36:00 PM CDT, 'Nicky Avery' via
RBASE-L <rbase-l@googlegroups.com> wrote:
On Wednesday, June 18, 2025 at 02:31:55 PM CDT, Doug Hamilton
<bugl...@wi.rr.com> <mailto:bugl...@wi.rr.com> wrote:
Labels to be printed are selected WHERE LabelsPrintedDTS IS NULL.
Doug, when you create a new order, had you tried assigning a default
value of 0 to LabelsPrintedDTS rather than no value? Once printed, you
can change it to 1. This way you search on ... WHERE LabelsPrintedDTS
= 0 rather than NULL.
Nicky
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/dedc6469-0161-4ea0-b20d-c43b8e7a3e4e%40wwavs.com
<https://groups.google.com/d/msgid/rbase-l/dedc6469-0161-4ea0-b20d-c43b8e7a3e4e%40wwavs.com?utm_medium=email&utm_source=footer>
.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/893739093.98776.1750279295341%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/893739093.98776.1750279295341%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
www.avast.com
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/f5345a84-4b6c-4247-af0d-613f333a1001%40wi.rr.com.
