Meaning of the error

Error came while running the code .What is the meaning of that code?

Hi @anjani_priya,

some time project converted windows to legacy, it showing this.


HI @anjani_priya

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.

  1. 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.
  2. 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.
  3. 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

Hi @anjani_priya

originalDate = “30.04.2021”

formattedDate= DateTime.ParseExact(originalDate, “dd.MM.yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MMM yyyy”)

Hi @anjani_priya

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.