CREATEDATETIME Filter Problem

ricky76

Hi, i was wondering if anyone could help me. I want to be able to give the user the choice of what year to enter in order to give them a summary of that particular year. From the integer they enter into the text box i want to create a datetime and then filter the report on this. Trouble is the field i want to filter on is a date field. I thought i would just create a datetime field on the date field but this has not worked. This is what i have tried but it hasn't worked. Can anyone help me??

SETRANGE(CREATEDATETIME("Posting Date",0T),CREATEDATETIME(DMY2DATE(1,4,IntYear),0T),CREATEDATETIME(DMY2DATE(1,4,IntYearPlus1),0T));

Marije_Brummel

To build a date you can use

DMYTODATE(1,1,YearVar)

This way you can filter on a datefield.

kriki

So probably you should write something like:

SETRANGE("Posting Date",DMY2DATE(1,4,IntYear),DMY2DATE(1,4,IntYear + 1));

ricky76

This all makes sense and the report likes the code however it still brings in records outside the range. Any ideas?

Marije_Brummel

Maybe the filter is being reset after you set it.

Have you used the debugger on this?

ricky76

Thanks i have it sorted. I was using an alias of the table in the code which i didn't need. Many thanks for your help.