C# .NET - Date Query - Asked By Deven Thakur on 28-Jul-16 08:58 AM

how to make any string to a particular date?

 for example if it is "Jun-2016" so it will be "30-06-2026"
 
and if it is selected "Mar-2016" so it will be "31-03-2026"
Robbe Morris replied to Deven Thakur on 28-Jul-16 08:58 AM
Again, you'll have to CAST/CONVERT the value to a date or date time data type and then perform the conversion with something like DATEPART or its equivalent in the database you are using.