Have you tried “Format Value” activity and let me know.
CultureName = Provides information about a specific culture (called a locale for unmanaged code development). The information includes the names for the culture, the writing system, the calendar used, the sort order of strings, and formatting for dates and numbers.
For E.g. for German culture you can out this into CultureName property “de-De”.
DateTimeStyles- Defines the formatting options that customize string parsing for some date and time parsing methods
For e.g. you can use “DateTimeStyles.NoCurrentDateDefault”(If the parsed string contains only the time and not the date, the parsing methods assume the Gregorian date with year = 1, month = 1, and day = 1. If this value is not used, the current date is assumed.)
For your reference:
CultureInfo MyCultureInfo = new CultureInfo(“de-DE”);
string MyString = “12 Juni 2008”;
DateTime MyDateTime = DateTime.Parse(MyString, MyCultureInfo,
DateTimeStyles.NoCurrentDateDefault);
Console.WriteLine(MyDateTime);
I had misunderstood the purpose of Parse Date, that’s where I was going wrong… but on the right track now! Parse Date will be useful for some other data that I’m working with too.