(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Calculated Retrieve Spec
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Calculated Retrieve Spec (Read 658 times)
BWETTLAUFER
Full Member
***
Offline



Posts: 216
Location: Cambridge, Ontario
Joined: Apr 9th, 2010
Calculated Retrieve Spec
Mar 10th, 2021 at 5:34pm
Print Post Print Post  
Hey folks ... I have a text field that I use to keep a log of letters sent, so it might look like this:

2021/02/08 ELA Sent
2021/03/10 ELB Sent

I'm trying to build a calculated retrieve that excludes records that might have had a letter this month or last month, and it's not working.

How can I do a calculate retrieve like:

/..2021..03..LA..;..2021..02..LA..

It doesn't seem to work in any of the following things I've tried:

/..@year(@date)..@month(@date)..LA..
/..@year(|@date|)..@month(|@date|)..LA..

Help?
  
Back to top
WWW WWW Twitter Twitter  
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Calculated Retrieve Spec
Reply #1 - Mar 10th, 2021 at 5:41pm
Print Post Print Post  
Hi Blair,

Try:
Code
Select All
/..|@year(@date)|..|@month(@date)|..LA..


-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge