Forum Discussion

Brucejm's avatar
Brucejm
Regular Visitor
7 years ago

Comparing Date Fields doesn’t work

Hi, I have a strange issue.

 

im bas8cally trying to create a filtered set of data with filtering based around 3 fields.

 

2 fields come from an SQL server database and start of life as datetime2

 

1 comes by creating a calendar table and then calculating the month end of each date using EOMONTH()

 

I need to create a couple of relatively simple if statements to achieve this.

 

one is if(selectedvalue(calendar[month end]<tablename[posted date],1,0)

 

the other is if(selectedvalue(calendar[month end]<tablename[timeout],1,0)

 

the first statement is fine, it works perfectly, the second resolutely refuses to play ball and gives 0 regardless of the value of timeout.

 

i have even tried extracting month and year so I’m comparing numerical but that doesn’t work either.

 

Any ideas gratefully received as this one is causing me grief.

 

1 Reply

  • technolog's avatar
    technolog
    Super User
    3 years ago

    Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

    If not, it may make sense to ask the question again, thus confirming the relevance of this problem.