some time project converted windows to legacy, it showing this.
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
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
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.