Birthady Reminder

Learning Initatives Automation Starter
1

image
image1198×605 17 KB

error Assign: String was not recognized as a valid DateTime.

image
image755×299 9.2 KB

image
image1166×576 16.1 KB

image
image998×568 14.1 KB

how to solve error please date conversion

2

Hi @nikhil.patil

Can you share the input and output format of the date

DateTime.ParseExact(Row("ColumnName").ToString,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM/dd")

Note : Just replace the correct Date format instead dd/MM/yyyy in the expression

Regards
Gokul

3

Hello @nikhil.patil

error Assign: String was not recognized as a valid DateTime.
This error is because the string value from Row(1) your trying to convert is not in the required format in which system is expecting it to be.

Use Date parsing method to specify the format of your input string
DateTime.ParseExact(Row(0).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM/dd”)

Here if your date is not in dd/MM/yyyy format then replace it with the correct format. (Ex: MM/dd/yyy)

Regards,
Rohith

4

Assign: The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.

image
image795×302 10.4 KB

i m sending my workflow please error solving
Main.xaml (11.1 KB)

5

Hey!

Check this xaml

Main.xaml (14.8 KB)

Regards,
NaNi

6

Hi ,

Instead of for loop , you can use the Lookup activity to check if current date is in the Datatable . If the Value is not -1 ,then you can take index of current row and send happy birthday to column(0).

Happy Automation.

7

@nikhil.patil - Can you share the excel file