We are often spoiled by the number of functions that are built into the WL language. This is especially true with it comes to date and time manipulation. I have never worked with an environment that has so many built in functions for dealing with dates. So it came as a bit of a shock … Continue reading Adding Suffix (st, nd, rd, th) to Numbers
Category: Quick Tips
Working on integrating with Amazon S3 services today, which uses a RESTful API. So far the hardest part is generating the login credentials. Amazon does this quite a bit different than most services. Instead of just sending an API Key and Token, you use several pieces of information, including the actual REST URL you are … Continue reading Getting UTC Time in ISO 8601 Format
How to work around the "Directory Does not exists in SCM Database" bug.
Normally when I want a PDF generated from a report I do so by using the iDestination function, similar to this: The generated PDF will have the name specified by the variable PDFFileName. But recently a Client had a report that we were using the Print Preview for, however when the user saved the report as … Continue reading Setting PDF Filename when using Print Preview
I spent part of my morning in .NET hell, a situation that I try to avoid as much as possible. That is the reason I use WX in the first place! I use a .NET library to convert JSON data to XML data, which will be the topic of a future webinar. But today's topic … Continue reading .NET Permission Issues
Ran into a very subtle issue today with variables declared in a loop. For pcreminder.com, I have an outer loop that gets all the reminders that need to be sent for all users. Within that loop, there is a second loop that loops through all the receipts for the reminder and sends the actual reminder. … Continue reading Variables declared in a Loop
A few weeks ago I gave someone an answer that included code similar to this: IF Nospace(MyString) = "TestString" And Wolfgang Kirsch pointed out the flexible comparison operators in the online help. So the statement can be written as IF Mystring ~= "TestString" I have been trying to use this more as I feel it … Continue reading Flexible Comparison Statements