In this step by step tutorial for beginner, learn how to use the DateTimeToString function in report builder.
DateTimeToString function used to convert a date and time 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:20 Introduction
00:21–00:44 Step 1 : Declaration Variable
00:45–01:11 Step 2 : Explanation on DateTimeToString Function
01:12–02:08 Step 3 : Construct SQL Queries
02:09–02:48 Step 4 : Retrieve Query Results
