Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
%SI_STARTTIME% Question
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Wojo
Past 24 Hours:
1
Prev. 24 Hours:
0
Overall:
5265
People Online:
Visitors:
321
Members:
0
Total:
321
Online Now:
New Topics
Lawson S3 Procurement
Tolerance Settings
3/31/2025 2:01 PM
I've been trying to set a tolerance for some t
Dealing with Lawson / Infor
Printing Solutions other than MHC
3/27/2025 1:00 PM
What are others using for printing solutions besid
Lawson S3 Procurement
Green check marks in Lawson 9.0.1
3/20/2025 4:55 PM
Hi, How to remove green check mark on items when o
Lawson S3 HR/Payroll/Benefits
Pay Rate History to Show All Positions
2/26/2025 3:34 PM
Does anyone know how to modify payratehistory.htm
Infor CloudSuite
How to build a Pre-Prod tenant
2/7/2025 1:28 AM
After we finished our implementation and ended our
Lawson S3 Procurement
Browser issue with RQC Shopping
1/28/2025 5:49 PM
Since the recent Chrome/Edge updates, our RQC shop
Lawson S3 Procurement
S3-Procurement New Company
1/22/2025 10:38 PM
My Accounting Department has created a new Company
S3 Customization/Development
JUSTIFIED RIGHT
1/15/2025 7:41 PM
Is there a way in Lawson COBOL to make a character
S3 Systems Administration
ADFS certificate - new cert
12/3/2024 9:38 PM
The certificates on the windows boxes expired and
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1375
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
%SI_STARTTIME% Question
Please
login
to post a reply.
7 Replies
0
Subscribed to this topic
22 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Cindy
New Member
Posts: 0
6/29/2009 7:12 PM
Is there a way to make this statement exclude the time?
%SI_STARTTIME%
I only want the date and no time on it.
Thank you.
Cindy
<!-- / message -->
Matthew Nye
Veteran Member
Posts: 514
6/29/2009 7:24 PM
Split
try ToText({MYFIELDNAME }, "dd-MMM-yyyy")
Char
Veteran Member
Posts: 62
6/30/2009 11:38 AM
Split
I've used %SI_STARTTIME% in Enterprise within the email subject or filename when scheduling a report to distribute via email but I've never used it within LBI; is this what you're attempting to do? If you have a full copy of CR Server or Enterprise, you can go to the query builder and "SELECT *" where your "SI_ID = X" - for X go to a historical instance and click the sucess; it will show you the SI_ID within the path right after all of the file folders are finished displaying and right before the ~xxxxxxx.rpt. This will show you every field that is exposed and available through the SDK. Even then, I"m not sure they built the hooks to allow the use of every field available from the SDK within the SMTP interface. Sorry it's not a direct answer but it should put you on the path to find the answer. I'll be attaching to an Enterprise environment later today so if you can confirm your exact goal, I'll be happy to do the query to get the available fields from the CMS
Cindy
New Member
Posts: 0
6/30/2009 12:44 PM
Split
Yes, I'm trying to use it in Enterprise within the filename when scheduling a report to distribute via email. Thanks for the tips. I will try both suggestions.
Cindy
Char
Veteran Member
Posts: 62
6/30/2009 1:12 PM
Split
Okay, that makes sense - I didn't think that was available in LBI. That should do it for you then, you might also look at the SI_ID of a scheduled instance going to email - you'll find different properties within differnt object types report vs. instance for example. Also, a report scheduled to Excel will have different properties than one going to just history so looking at different instance types will be important to finding what you're after.
Cindy
New Member
Posts: 0
6/30/2009 2:08 PM
Split
Char, where would I find the query builder in the Crystal Management Console? Thanks.
Char
Veteran Member
Posts: 62
6/30/2009 2:47 PM
Split
I'm telling you from memory so I may not have it exact - go to the Admin Launchpad and on the left side of the screen there are either two or three windows; I think one says "admin tools" - you'll see links to things like the Instance Manager there - one link will say somelthing like Query Builder or something similar.
Cindy
New Member
Posts: 0
6/30/2009 4:13 PM
Split
OK, thanks
Please
login
to post a reply.