Date Values in row.tostring

Help Studio
1

Hello, if someone can help me.

In a for each row cycle, compose an email but the values are not the same

Subject =row(“subject”).ToString

Excel: Via Verde Outubro 2020
Email: Via Verde October AAAA

2

This is odd. It’s unlikely but using a value by directly referencing inside the table might be causing some issue.
Can you try assigning it to a variable and use the variable in the Subject field?
Also try printing it to console with Write Line or Log Message.

3

@Domingos_Pereira

Can you share use the sample subject screen and output screen

You can hide the sensitive data

Thanks

4

i realized that get values from excel that i can get from system isn’t the better solution, so i was able to resolve this issue using.

DateTime.Now.ToString(" MMMM ", System.Globalization.CultureInfo.CreateSpecificCulture(“PT”)).ToString.ToUpper +System.DateTime.Now.Year.ToString

however i think the issue is because i have in excel formules in PT to get month and year but ui path is no converting correctly.

thanks for all replys.

5

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