Convert date 12-01-2024 to date format "2024-01-12"

Help Studio
1

I have extracted date as

startdate = 12-01-2024 (its a string value)

I want to convert to date variable in format (2024-01-12)

can someone help again.

2

Hi @Ellen

Try this:

startdate = "12-01-2024" 
Output= Datetime.ParseExact(startdate.ToString, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")

Output DataType: System.String

image
image941×553 56.2 KB

Regards

3

Hi @Ellen

DateTime.ParseExact(Input,"dd-MM-yyyy",System.Globalization.CultureInfo.CurrentCulture).ToString("yyyy-MM-dd")

image
image885×353 17.2 KB

Regards,

4

please let us know if 12 is Month or Day

5

@Ellen

DateTime.ParseExact(StartDate, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")

image
image924×396 15.7 KB

6

@Ellen

OutputDAte=DateTime.ParseExact(startDate, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

Import System.Globalization

1 Like
7

Hi @Ellen

startdate = “12-01-2024”

Output=

Datetime.ParseExact(startdate.ToString, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

Output = 2024-01-12

Hope it will helps you :slight_smile:
Cheers!!

8

Hi ,

Use assign activity and put this on right side
Datetime.ParseExact((“12-10-2024”).ToString, “dd-MM-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

9

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