If and Statement with Date Range as one condition

[ruddikl]

Hi!

I'm attempting to write an If statement that is needs to Check the "Posting Date" column for a value that is not the first day of that month (Not the current month) I also need it to ensure a different column has the term "DEM_ACC in it. I think its returning the first of the current month and not the month I need (April) but I cannot figure out how to make it work.

Here is what I have so far, but I cant get the date functionality to work for me

IF [Posting Date]>DateTimeFirstOfMonth() AND
[Type Code 1]="DEM_ACC"
THEN "1"
ELSE "0"
ENDIF

[mbarone · Accepted solution]

IF [Posting Date]>DateTimeTrim([Posting Date],'firstofmonth')

[ruddikl]

Thank you so much! So easy, and yet I have been struggling for a few hours!

[mbarone]

We've all been there, very welcome!

[cmcclellan]

Another tip ..... don't use

THEN "1"

that creates a string field that is (really) a number, instead use

THEN 1

make sure the datatype is numeric and that makes it easier to add later without the need to change datatypes again