Convert string to date issue

Help Studio
, ,
1

Hello all
I am trying to convert string to date.

String = 12/24/2015
Expected output =2016-02-01 ( need to add 9 days)
I am using this code = DateTime.ParseExact( str_Date,“yyyy-dd-MM”, System.Globalization.CultureInfo.InvariantCulture).AddDays(9)

Getting error :
image

2

@Dinesh5

str_Date = "12/24/2015"
output_Date = DateTime.ParseExact(str_Date, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).AddDays(9).ToString("yyyy-MM-dd")
1 Like
3

Hi @Dinesh5

Try the below one,

- Assign -> Input = "12/24/2015"

- Assign -> Output = DateTime.ParseExact(Input.toString,"MM/dd/yyyy", System.Globalization.Cultureinfo.InvariantCulture).adddays(9).toString("yyyy-MM-dd")

Hope it helps!!

1 Like
4

@rlgandu So I need to give same date format as string(MM/DD/YYYY) first I need to convert it to expected format?

5

@Dinesh5

DateTime.ParseExact(str_Date, “MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).AddDays(9).ToString(“yyyy-MM-dd”)
“MM/dd/yyyy”---- you have to pass str_Date Format
“yyyy-MM-dd”-------Your Expected Format

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.