Creating reports and dashboards | Stimulsoft community forum

I need to match a datetime field (from the dictionary) with a fixed date. Eg. MyDateFromDictionary >= "20111020". Script report is in C#.

Thank you.

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

Sure. In my datasource i have a datetime column called "MyDate". In its field of the report, if "MyDate" is between two specific dates (eg. 01/01/2011 and 31/01/2011) i must print "x", else i must print "y".

I don't know how to create the IIF statement to see if the "MyDate" column is between the two fixed dates (i have tried several ways but with errors).

Thank you.

Hello.

Fabio wrote:Sure. In my datasource i have a datetime column called "MyDate". In its field of the report, if "MyDate" is between two specific dates (eg. 01/01/2011 and 31/01/2011) i must print "x", else i must print "y".

I don't know how to create the IIF statement to see if the "MyDate" column is between the two fixed dates (i have tried several ways but with errors).

Please, try to use variables. See attached report template.

Thank you.

My intention was to write, in the field, the fixed value of the date, example:

{MyDate>"20111031" && MyDate<"20111001"?'Y':'X'}

but this raises the compilation error:

"Unable to apply operator "<" to operands of tpye "System.DateTime" and "string"."

This is correct, because the two operands are different: i have tried to convert one type to another but i have had other errors. So at this point i need to know how to convert the date in string or the string in date.

Thank you.

Hello.

Fabio wrote:My intention was to write, in the field, the fixed value of the date, example:

{MyDate>"20111031" && MyDatenew DateTime(2011,10,31) && MyDate < new DateTime(2011,10,01)?'Y':'X'}

Thank you.

I have tried, in a group footer, the following expression:

{Sum(Movimento.Movimento__Data_documento> new DateTime(2010,01,01) && Movimento.Movimento__Data_documento< new DateTime(2012,12,31)? 1 : 2)}

but the following error appears:

"The name "newDateTime" does not exists in the current context" (Note 1: i have translated the message from Italian - Note 2: in the error message, "newDateTime" appears without spaces).

Thank you.

Hello,

Please send us your report with test data for analysis.

Thank you.

I have sent the data and the report to support@stimulsoft.com.

Thank you.

Thank you, Fabio.