Can you debug and check that what ever your passing in the assign activity it should not initialise or else increase the scope of that variable
I have checked for other sheets also but this error didnt come.
- Null or Uninitialized Variables: Ensure that all variables and objects used in your workflow are properly initialized. If a variable is set to Nothing or not initialized, you might encounter this error. Check all variables and object references for proper initialization.
- Missing or Misconfigured Variables: Review your workflow and verify that all variables used in your activities have been defined with the correct data types and have appropriate values assigned.
- Check for Empty Values: When using activities that return values (e.g., Excel activities, database queries, etc.), make sure to validate the results before using them. If a query returns no data, you might get a null reference exception when trying to access the result.
I have same data in another excel file but it came but in this file its showing error
Is it throwing error with excel activity or assign activity
Can u share the screenshot of the activity where it’s failing @anjani_priya
how to change this 30.04.2021 into apr 2021
1 Like
originalDate = “30.04.2021”
formattedDate= DateTime.ParseExact(originalDate, “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM yyyy”)
you can try this
strinput = 30.04.2021
DateTime.ParseExact(strinput, "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MMM yyyy")
OutPut : -
You can do like this
stroutput = DateTime.ParseExact(strinput, “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM yyyy”).ToLower
You can get to know all the Datetime conversion here from my post
Hope this helps
Cheers @anjani_priya
It means you are trying to reference a variable that has not been initialized. What is the activity that is throwing the error?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.