Appending date in FileName - Vb.net

vb.net

Solution

Chech below code

VB.Net

Dim FileName As String = "Events_Data.csv"
FileName = FileName.Replace(".csv", "_" & System.DateTime.Now.ToString("yyyyMMdd") & ".csv")

C#.Net

string FileName = "Events_Data.csv";
string ptest =System.DateTime.Now.ToString("yyyyMMdd");
FileName = FileName.Replace(".csv", "_" + ptest  + ".csv");

Problem

I have got this FileName = "Events_Data.csv" I want to add date to this, so output required is FileName = "Events_Data_20140521.csv" I have got data in separate variables, just don't know how to add this before .csv in the file name. Can anyone please help. Regards

Original source