DateTime Manipulationn,,,,

String Manipulation DateTime Parse Extract:

Input: “05/Apr/2024”

output: 2024/05/Apr

Thanks,

Please send me the workflow steps,

Hi @sagarinavya6

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

Regards,

@sagarinavya6

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


@sagarinavya6

Assign: InputDate “05/Apr/2024”

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

Cheers

@sagarinavya6

Regards,

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,

Hope it helps!!

Hi @sagarinavya6

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

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