If and Statement with Date Range as one condition

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

Topic of Interest

Accepted answers

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

All comments

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

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

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

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703