DateTime Manipulationn,,,,

Help Studio
, ,
1

String Manipulation DateTime Parse Extract:

Input: “05/Apr/2024”

output: 2024/05/Apr

Thanks,

Please send me the workflow steps,

2

Hi @sagarinavya6

FinalDate = DateTime.ParseExact(inputDate, "dd/MMM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy/dd/MMM")

Regards,

3

@sagarinavya6

1. Assign
   - inputDate = "05/Apr/2024"
2. Assign
   - parsedDate = DateTime.ParseExact(inputDate, "dd/MMM/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy/dd/MMM")
4

@sagarinavya6

Assign: InputDate “05/Apr/2024”

Assign: OutputDate = DateTime.ParseExact(InputDate,"dd/MMM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy/dd/MMM")

image
image681×518 8.93 KB

Cheers

5

@sagarinavya6

image
image910×500 18.9 KB

Regards,

6

Hi @sagarinavya6

You can use the DateTime Manipulation expressions to get the date in required format,

- Assign -> InputDate = "05/Apr/2024"

- Assign -> OutputDate = DateTime.ParseExact(InputDate.toString, dd/MMM/yyyy", System.globalization.cultureinfo.InvariantCulture).toString(""yyyy/dd/MMM")

Check the below image for better undestanding,

image
image778×471 14.4 KB

Hope it helps!!

7

Hi @sagarinavya6

DateTime.ParseExact(InputDate.toString, dd/MMM/yyyy", System.globalization.cultureinfo.InvariantCulture).toString(""yyyy/dd/MMM")