SQL Customization Report – FormatDateTime Function

In this step by step tutorial for beginner, learn how to use the FormatDateTime function in fr3 Report, which is used to convert a date value into a string format for use in SQL queries.

For this video, we’ll demonstrate how to use this function to capture the total outstanding invoice amount for a customer up to Sales Invoice Date.

𝐓𝐢𝐦𝐞 𝐒𝐭𝐚𝐦𝐩𝐬
00:00–00:22 Introduction
00:23–00:33 Step 1 : Declaration Variable
00:34–01:06 Step 2 : Explanation on FormatDateTime Function
01:07–01:52 Step 3 : Construct the SQL Query
01:53–02:33 Step 4 : AddDataset and LinkTo Methods
02:34–02:53 Result