Is it possible to convert the $entryDatePropertyName from "dd.mm.yyyy" in "yyyy-MM-dd"?

Question

As we use the dateformat dd.mm.yyyy I set it as required in this format in the regesp.

Is it possible to convert the CustomAttributeText5 from "dd.mm.yyyy" in "yyyy-MM-dd" as we would need it in the email as yyyy-mm-dd format?

Or is it required to set the Regexp as desired for adm-CustomAttributeText5?

I have already tried to add this line:

$entryDate = [datetime]::ParseExact($entryDatePropertyName, "dd.MM.yyyy", $null).ToString("yyyy-MM-dd")

Answer 1

Hello Fabian,

Of course, it is recommended to make sure that dates are directly entered in the required format to avoid any further parsing. However, the line you provided works just fine as per our check. What makes you think it does not? What exactly do you pass to $entryDatePropertyName?

Comments

My code:

`$entryDatePropertyName = "adm-CustomAttributeText5" # TODO: modify me

# Convert date from "dd.mm.yyyy" to "yyyy-MM-dd"

$entryDate = [datetime]::ParseExact($entryDatePropertyName, "dd.MM.yyyy", $null).ToString("yyyy-MM-dd")

# Get member property value

$member = $Context.BindToObjectByDN("%member%")

try { $memberPropertyValue = $member.Get($entryDatePropertyName) } catch { $memberPropertyValue = "already existing user" }

# Send mail

$emailBody = [System.String]::Format($emailBodyTemplate, @($memberPropertyValue)) $Context.SendMail($to, $subject, $emailBody, $NULL)` This is the error message I get from adaxes:

---

Hello Fabian,

The behavior is expected as you are passing the property name to the parser instead of a date. Below is the updated full script.

$to = "recipient@company.com, recipient2@company.com" # TODO: modify me
$subject = "My Subject" # TODO: modify me
$emailBodyTemplate = @"
Hello,

The user %adm-MemberFullName% has been added to the %name% group.

Entry date: {0}
"@ # TODO: modify me

$entryDatePropertyName = "adm-CustomAttributeText5" # TODO: modify me

# Get member property value
$member = $Context.BindToObjectByDN("%member%")

try
{
    $memberPropertyValue = $member.Get($entryDatePropertyName)
}
catch
{
    $memberPropertyValue = "already existing user"
}

if ($memberPropertyValue -eq "already existing user")
{
    $emailBody = [System.String]::Format($emailBodyTemplate, @($memberPropertyValue))
}
else
{
    $memberDate = [DateTime]::ParseExact($memberPropertyValue, "dd.MM.yyyy", $null).ToString("yyyy-MM-dd")
    $emailBody = [System.String]::Format($emailBodyTemplate, @($memberDate))
}

# Send mail
$Context.SendMail($to, $subject, $emailBody, $NULL)

---

thank you!