SQL – How to convert datetime to formatted date string dd-mm-yyyy
Learn how to convert a datetime column to a formatted date string in SQL using the CONVERT function. Discover different date formats available and their corresponding values.
Date
SQL – How to select current year from lookup table
This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…
Crystal Reports – How to convert a date to day
Learn how to convert a date to its corresponding day of the week using formulas in Crystal Reports with our step-by-step guide featuring the DayOfWeek and WeekdayName functions.\*Please include one…
SQL – How to get current financial year using SQL
Learn how to retrieve the current financial year in SQL with this simple and effective solution, assuming the fiscal year starts on July 1st and ends on June 30th. Get…
SQL – How to select current financial year from lookup table
This SQL query demonstrates how to retrieve the current financial year from a lookup table by utilizing the current date, month, year, and cast functions. It returns the selected row…
How to automatically delete entries after a month
This tutorial explains how to use Gravity Forms Entry Automation to automatically delete entries older than one month using specific configurations.
How to automatically send weekly registration summary
This tutorial explains how to use Gravity Forms, Entry Automation and ForGravity to create a weekly registration summary email with a CSV attachment.
How to automatically export payment summary using Gravity Forms
How to Setup Daily Payment Summary via Gravity Forms and Entry Automation
How to create a WordPress plugin for your custom actions and filters
Learn how to create a WordPress plugin for your custom actions and filters to avoid losing changes when updating themes, and enjoy benefits such as version control and ease of…