How to format the Date
If the $dt parameter contains the DateTime structure and you want to format the date as "year-month-day", use the DateTime.ToString method like this:
1 | $dt.ToString("yyyy-MM-dd") |
Book a Presales Call
Related Articles
Sample template text to create CSV from DataReader Destination
In the Template Editor dialog, check the 'Remove Newline' parameter. The Current object below implements the standard ADO.NET IDataReader interface. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 #macro( main $reader ) ...Pass two objects to the Template Task
1 2 3 4 5 #macro( main $list1 $list2 ) ... ... #end #main( $list1 $list2 )What is the difference between Template Task and Template Component
Template Task have to be used when you would like to generate complex document, with input from multiple data flows. The Template component is recommended when you would like to generate result document, based only on one data flow input columns.What is the proper date/time format for the RemoteFilter parameter on the File Transfer Task?
If you want to use a filter for the remote files that includes both the date and the time, use the following format: TimeSpan - A string in the format ##[d.]hh:mm[:ss[.ff]]#. Example: #08/06/2008# + ##1.23:45#What format should I use for the time and date in the LocalFilter parameter of the File Transfer Task?
Use a FLEE expression. The syntax for the time is: ModifiedTime >= #06/29/2023# + ##09.00:00#