Convert Date Time and Decimal to user specific format

Vishal Chaudhari

I am writing a function to convert Decimal/Datetime to the format specified by user.

For example:

If my input string is 1234.1254 and format string is "000.00" then the output should be 1234.13.

Same goes for Datetime, if input is DateTime.Now and format string is "dd/MM/yyyy" then the date should be returned in the given format.

I am not sure how can I achieve this, any suggestions on how can I proceed here?

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satya Karki5y ago
You can format simply:
Math.Round(decValue, 2) // for decimal output
var result = (1.7289).ToString("#.##"); // for string output
And then datetime
var returnValue = DateTime.Now.ToString("dd/MM/yyyy");
For more details:
https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings
Rijwan Ansari5y ago
For Decimal Round figure:
decimal decValue = 21234.122122;
var roundValue = Math.Round(decValue, 2); // roundValue = 21234.12
You might also want to look at bankers rounding / round-to-even with the following overload:
Math.Round(DecValue, 2, MidpointRounding.ToEven);
For String output:
String.Format("{0:0.00}", 140.6767554);        // "140.67"
String.Format("{0:0.00}", 140.1);             // "140.10"
String.Format("{0:0.00}", 140);              // "140.00"
var a = inputStringValue.ToString("0.00");
For DateTime:
DateTime date1 = new DateTime(2008, 1, 2, 6, 30, 15);
var formatDate = date1.ToString("dd/MM/yyyy")
Sachin Singh5y ago
these are the different date fromats , you need to map user specified format to equivalent format
Console.WriteLine(aDate.ToString("MM/dd/yyyy"));
            Console.WriteLine(aDate.ToString("dddd, dd MMMM yyyy"));
            Console.WriteLine(aDate.ToString("dddd, dd MMMM yyyy"));
            Console.WriteLine(aDate.ToString("dddd, dd MMMM yyyy"));
            Console.WriteLine(aDate.ToString("dddd, dd MMMM yyyy"));
            Console.WriteLine(aDate.ToString("dddd, dd MMMM yyyy"));
            Console.WriteLine(aDate.ToString("dddd, dd MMMM yyyy HH:mm:ss"));
            Console.WriteLine(aDate.ToString("MM/dd/yyyy HH:mm"));
            Console.WriteLine(aDate.ToString("MM/dd/yyyy hh:mm tt"));
            Console.WriteLine(aDate.ToString("MM/dd/yyyy H:mm"));
            Console.WriteLine(aDate.ToString("MM/dd/yyyy h:mm tt"));
            Console.WriteLine(aDate.ToString("MM/dd/yyyy HH:mm:ss"));
            Console.WriteLine(aDate.ToString("MMMM dd"));
            Console.WriteLine(aDate.ToString("yyyy’-‘MM’-‘dd’T’HH’:’mm’:’ss.fffffffK"));
            Console.WriteLine(aDate.ToString("ddd, dd MMM yyy HH’:’mm’:’ss ‘GMT’"));
            Console.WriteLine(aDate.ToString("yyyy’-‘MM’-‘dd’T’HH’:’mm’:’ss"));
            Console.WriteLine(aDate.ToString("HH:mm"));
            Console.WriteLine(aDate.ToString("hh:mm tt"));
            Console.WriteLine(aDate.ToString("H:mm"));
            Console.WriteLine(aDate.ToString("h:mm tt"));
            Console.WriteLine(aDate.ToString("HH:mm:ss"));
            Console.WriteLine(aDate.ToString("yyyy MMMM"));
for example if user says i want format as dd/mm/yyyy then store that in string pass that to ToString()
string format= "dd/mm/yyyy";
var yourdate=date.ToString(format);
similarly for Decimal
string format="0.00";

var yourNum=DecimalNum.ToString(format);