MySQL: Find data entered on this date one year ago

April 25th, 2020

To find data entered into a MySQL database on this date one year ago you can use the MySQL date functions in your SQL query. The functions to use are:-

 

NOW – this gets the current date and time.
DATE – this extracts the date portion of a time value.
DATE_SUB – this subtracts an interval to a date/ time value.
DATE_ADD – this adds an internval to a date/ time value.

 

For example, if you have a field EntryDate in a table called Payments you can find all payment made on this day one year ago using a SQL query like this:

SELECT * FROM `Payments` WHERE EntryDate > DATE_SUB(DATE(NOW()), INTERVAL 1 YEAR) AND EntryDate <= DATE_SUB(DATE(DATE_Add(NOW(), INTERVAL 1 DAY)), INTERVAL 1 YEAR)

The parts of the query that look for EntryDate values between the start of the day one year ago and the start of tomorrow one year ago are:

 
EntryDate > DATE_SUB(DATE(NOW()), INTERVAL 1 YEAR) 

 

This expression gets the date part of the time now using:

 
DATE(NOW())

 

which gets the start of today, i.e. midnight, then subtracts 1 year using DATE_SUB. and then:

 
EntryDate <= DATE_SUB(DATE(DATE_Add(NOW(), INTERVAL 1 DAY)), INTERVAL 1 YEAR)

 

which adds 1 day to the start of today then subtracts one year.

Free Email Client for Windows 10

February 19th, 2020

For a very useful, free desktop email client for Windows 10, try out Mozilla Thunderbird available for download from this website:

https://www.thunderbird.net/

A number of desktop software programs need to be able to launch email clients, e.g. SliQ Invoicing requests Windows to launch an email client when you ask to email an invoice. In Windows 10, Microsoft have made this more difficult than in previous versions of Windows by no longer providing a free email client that supports a protocol called Simple MAPI for which free programs like Outlook Express or Windows Live Mail used to be available. A lot of people have bought Microsoft Outlook for email but, if you don’t have Outlook, we now recommend downloading and trying out Thunderbird as a free alternative.

Stop Snagit Editor Popping up When Snipping Tool Captures an Image

February 19th, 2020

Snagit is a great image editor and capture tool but sometimes it is more convenient to capture using the Windows Snipping Tool. However, by default, Snagit runs up its editor when it detects the Snipping Tool capturing an image. This can be somewhat annoying if all you need to do is quickly capture, copy and paste images into an email (for example) using the Snipping Tool.

To stop Snagit from popping up, do the following:

1. Run Snagit, i.e. run the Snagit Capture tool.

snagit-capture

2. Under the File menu, Choose the Capture Preferences option.

3. Uncheck the Open screenshots copied from System Tools checkbox …

 

snagit-capture-preferences

 

Now you can snip in peace without the Snagit editor popping up.

 

 

 

Why Develop an Online Invoicing Package

October 20th, 2017

We’ve recently been asked why we developed an online version of our SliQ Invoicing software. To be sure, it has been a significant effort with a need to learn and apply new, different technologies to those used for our desktop software. Having said this, we were able to reuse some components from our desktop software for things like template editing, PDF creation, printing and so on. Ultimately, we’ve implemented the online version to meet requests from our customers. We had many requests to implement multi-user access, multi-currency and mobile access, i.e. the ability to raise invoices while out and about. We took the decision that implementing an online version was the best solution to hit the majority of our customer requests. We’ve learned a lot of things along the way and will implement some of the major features back into the desktop version – multi-user and multi-currency for example.

From our point of view, a major advantage of the online software compared to the desktop software is that not only is there nothing for a customer to install in order to begin raising invoices but the online software is always right up to date – any changes or improvements we make can be made instantly available to all users without the need for people to be notified of an update, for them to decide to download and install and so on. Support also becomes much easier. With desktop software, our package may occasionally be affected by other software installed on a customer’s PC/  Mac/ tablet/ phone. With online/ cloud based X software the likelihood of an incompatibility reduces to almost zero since everything runs on a server in the cloud except for the web pages in the customer’s web browser.

Since launch we’ve been asked a couple of times why the online application looks different to the desktop application. In part, the difference is that it would take a lot of effort to make any web application look completely like a desktop application. We also took the opportunity to come with what we felt was a very clean user interface with the intention that keeping the interface clean made the application easier to use. Any user of our desktop invoicing software that tries out our online invoicing software should find the application easy to navigate. Users should also find that the features present in the desktop application are easily recognisable in the online app.

For the online invoicing application the help documentation is located at:

http://help.invoicing-software.com

We will continue to add more help articles to this website over time and will prioritise by first adding articles that address customer questions.

For more information on our online invoicing software, please visit:

https://www.invoicing-software.com

 

 

 

SliQ Invoicing Online

October 14th, 2017

Following our successful desktop invoicing system SliQTools have launched an online version. This is an expertly built tool that is perfect for the new start up business as well as the established business owner.  Features unique to the online system are the facility to invoice in what ever currency you need – yes it is a multicurrency package, and you can have multiple users accessing the company at any time – yes it is multi user package too – from any location.

SliQ Online software has been beautifully created by the experts at SliQTools Ltd.  It helps you produce your invoices using your own bespoke templates and engage closely with your customers for the ultimate goal – being paid on time.

Unique to SliQ Online is an invoice template designer. Do you already use SliQ Invoicing Plus, our desktop version – the template editor for SliQ Invoicing Online is very similar. You can get the new online template editor by downloading it from the Choose Template setup page while logged into SliQ Online. After entering your API key (found in the Setup/ Manage Account page in SliQ Invoicing Online), the template editor will let you edit the templates in your online account.

online-invoice-template-editor

 

SliQ Invoicing Online has a clever tool that enables you to set up a recurring invoice.  Say you invoice the same amount to the same person or business every month then you just need to set this up once, enter a few parameters and you are away.  SliQ Online  will do the rest for you.

To find out more, visit https://www.invoicing-software.com. Visit feature tour to get an overview of the features in SliQ Invoicing Online.

Make Life Easy by Invoicing Online

October 12th, 2017

I was chatting with a fellow passenger on the train from Barmouth. He owned a holiday letting business. He was telling me he had spent the day scanning in paper invoices from cleaners in order to then post all the originals to the property owners. Poor you I thought, how backward, I thought surely your time is better spent marketing your properties.  So I suggested to him he encouraged his cleaners to use SliQ Online. Out pops my iPad , thanks Arriva Trains Wales for the free wifi, and I gave him an on the train training demo of the software. Excellent he said.  He hadn’t realised how simple to set up it was.  And for £6 a month his cleaners would then email everything to him and cc the owners and he saves all that time.  No brainer he said.

That’s just one example.

The cleaners can now analyse which properties they make the most income from. They can produce reports for the tax man of how much has been invoiced

So if you have a business you can’t get out of raising invoices and the least amount of time you spend on it the less painful and costly it is. Your customers are happy because they know what they owe. If they lose your invoice you can easily send them a copy. Try out SliQ Invoicing Online at https://www.invoicing-software.com/.

Example of Bootstrap Dropdown menu in Kendo Grid

August 21st, 2015

After some trial and error I got a bootstrap dropdown menu working in a Kendo grid using code like this:

<blockquote>columns.Bound(theitem => theitem.ID).ClientTemplate
(“<a href=’/” + @”\#” + “/Items/Items_Update/” + “#=ID#” + “‘ class=’btn btn-xs btn-info’ rel=”nofollow”><i class=’icon-pencil’></i></a> ” +
“<div class=’btn-group’>” +
“<button type=’button’ class=’btn btn-default btn-xs dropdown-toggle’ data-toggle=’dropdown’>+<span class=’caret’></span></button>” +
“<ul class=’dropdown-menu dropdown-menu-right pull-right’ role=’menu’>” +
“<li role=’presentation’><a role=’menuitem’ tabindex=’-1′ href=’/” + @”\#” + “/Items/Items_Update/” + “#=ID#” + “‘ rel=”nofollow”>Edit</a></li>” +
“<li role=’presentation’ class=’divider’></li>” +
“<li role=’presentation’><a role=’menuitem’ tabindex=’-1′ href= ” onclick=’window.open(\”Items/OutputPDF/” + “#=ID#” + “\”” + “,\”_blank\”);return false;’ rel=”nofollow”>Download</a></li>” +
“</ul>” +
“</div>”
).Filterable(false)
</blockquote>

Now, I can show a Kendo grid/ list and have a dropdown menu on each row in the grid that I can use to take actions on grid items.

SliQ Invoicing and Windows 10 Support

August 4th, 2015

SliQ Invoicing works on Windows 10 as well as all earlier non-server versions of Windows from XP, through Vista, Windows 7, 8 and 8.1.

If you are taking up the offer of a free upgrade to Windows 10 from Microsoft and downloading Windows 10, during installation choose the option to keep your applications and personal data.

The Windows 10 upgrade process makes some identification changes to PCs. You may find that SliQ Invoicing Plus reverts to a trial copy as a result. If SliQ does display its trial notice dialog, press the Register button on the trial notice dialog SliQ displays when it starts and re-enter your unlock code to get back up and running. You can get your unlock code emailed to you via this web page:

http://www.sliqtools.co.uk/get-copy-of-unlock-code.aspx

We haven’t experienced any problems so far upgrading any of our PCs to Windows 10 with the exception that one of our older printers no longer worked. As no default printer was then selected in Windows 10, SliQ was unable to do a print or a print preview. If this is the case, go into Windows Settings and set a default printer. SliQ will then print and do a print preview OK. You can access Windows 10 Settings by clicking the new Start button at the bottom left of the screen and choosing Settings then accessing the Device and Printer settings option.

InstallShield Express Major Upgrade

April 22nd, 2015

I’ve switched to Installshield 2014 Express as my installer package of choice. I was using an older Premier version that mysteriously broke and looked around for other installer packages. Eventually however, the dependency management and scanning capabilities of Installshield won me back and I purchased Installshield Express as I only wanted to produce Simple MSI installers.

To produce a new installer in Installshield Express I needed to force a major upgrade to uninstall any older versions produced using my old installation package. After some experimentation to ensure that any later installer produced with Express could also upgrade older Express installers, I decided I would always use a major upgrade for every installer version I produced from then on. Other than including the relevant files and so on in the InstallShield project there are 5 key items you need to take account of when producing a major upgrade:

1. The product version number.

You need to increment this for each new installer you produce.

2. The Product Code.

This needs to change for every new installer you produce.

3. The Upgrade Code.

This should remain unchanged AND should match the Upgrade Code for any pre-Express installer.

4. The Package Code .

This needs to change for every new installer you produce.

5. Add an Upgrade Path to the Project if you don’t have one already

Dealing with these items one by one …

1. Product Version Number

In the Installation Designer, click Organize Your Setup->General Information, then enter your new Product Version Number.

product-version-number-organize-your-setup

2. The Product Code

In the Installation Designer, click Organize Your Setup->General Information, then click the {…} button in the Product Code row.

product-code-organize-your-setup

3. The Upgrade Code.

DO NOT CHANGE THIS!

upgrade-code-organize-your-setup

4. The Package Code

In the Installation Designer, click Releases, then click the Express node in the middle panel and click the {…} button to generate a new Package Code.

releases-package-code

5. Make sure you have an Upgrade Path …

In the Installation Designer, if you haven’t already done so, click Organize Your Setup->UpgradePaths then in the middle panel, right-click Upgrade Paths and add new path.

In the new upgrade path, enter the min and max versions. You can leave the min version blank but still set Include Min Version to Yes. Set the Max Version appropriately to limit the versions the installer will upgrade.

upgrade-path

Then build the installer and run. The installer should then uninstall any previous version of the software with the same package code whether the old installer was created with an older InstallShield or with InstallShield Express.

For help with major upgrades in other versions of InstallShield, see: http://www.sliqtools.co.uk/blog/technical/installshield-major-upgrade/

and

http://www.sliqtools.co.uk/blog/technical/installshield-major-upgrade-two-entries-in-add-remove-programs/

SliQ Invoicing Plus V5 Released

November 22nd, 2014

Version 5 of SliQ Invoicing Plus has been released. This is a major new version of SliQ Invoicing Plus and is released almost two years after V4. Over 100 additions and modifications have been included in version 5 based on feedback from customers.

The top user-requested features included in V5 are a built-in spellchecker when editing invoices and a stock control system for tracking stock level and helping automate raising orders for low stock items. V5 now also includes the ability to define HTML email templates, allowing users to add logos and formatted signatures to emails sent from SliQ, e.g. when emailing invoices to customers.

A number of smaller features have been added to increase flexibility, e.g. it is now possible to automatically insert date information into line item descriptions on recurring invoices. In V5 it is also possible to configure the date ranges used on ageing reports on statements to bring them in line with invoice payment terms if desired.

Existing customers can upgrade from any earlier version of SliQ Invoicing at the reduced upgrade price shown on our sales page. Any purchaser of V5 will be able to download any updated V5 release, e.g. 5.1, 5.2 etc. will be free updates for those who have already bought V5.

To find out more about the changes in V5, see our Release History page.