Hello all!
I have a string "8 Kasım 2024 Cuma 10:21:47" Turkish format string in PAD. I want to have a datetime format of this string. Please help me. I appriciate that.
I used powershell prompt. And it worked!
"# Gelen string değer
$stringValue = "%AttributeValue%"
# String değeri DateTime nesnesine dönüştürme
$dateTime = [DateTime]::ParseExact($stringValue, "d MMMM yyyy dddd HH:mm:ss", [System.Globalization.CultureInfo]::GetCultureInfo("tr-TR"))
# Yeni formata göre tarih ve saat değerini string olarak biçimlendirme
$newFormattedString = $dateTime.ToString("dd.MM.yyyy HH:mm:ss", [System.Globalization.CultureInfo]::GetCultureInfo("tr-TR"))
Write-Output $newFormattedString"
Yes, it doesn't work. because of language i think . I select Custom and typed d MMMM yyyy dddd HH:mm:ss
Hi @betuld
Did you get a chance to look at Convert text to datetime action available in PAD
Check below link for documentation
If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Cheers,
Srini