Current Month

[Anonymous]

Hi,

I would like to add a where clause to my data load editor to restrict data up to the current month. Can someone please assist me with how to add the below:

WHERE Date <= CurrentMonth

All the searches I have done in the forum only return calculations e.g. SUM

Thank you in advance for any assistance.

[gerry_hdm]

where month(Date) <= month(Today())

greetings Gerry

[rahulgoyal1287]

Hi Raman,

You can compare any date with following expression:

monthstart(TODAY())

it will return 1st day of the current month.. so you can compare it by using Field1 <= monthstart(TODAY()) .....

Hope it helps.

Best Regards,

Rahul

[ishanbhatt · Accepted solution]

Hi Raman,

If you want to restrict data up to the current month then use below mention solutions.

1. If you want to consider the whole month then,

          Where Date <= Monthend(Today())

2. If you want to load data up to today then,

          Where Date <= Today()

* Make sure that Date field format and system format are same.

[Anonymous]

Thanks, guys!