Date limiting question

[Anthony stark]

Hi Guys,

How do i modify the expression below to show only the reports that are added from the first day of the month, and not the last 30 days

case when [REPORTDATE]>=dateadd("dd",-30,DateTimeNow())

 

for example, i would like it to show only the reports that were added from the 1 day of october, and when in november its should do the same for november and so on.

Thanks in advance

[Michael Kalada 2]

[REPORTDATE]>=Date(

Concatenate(

DatePart('mm', DateTimeNow()),'/01/',DatePart('yy',DateTimeNow())))

 

not very elegant, but it works