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
Solved! Go to Solution.
IF [Posting Date]>DateTimeTrim([Posting Date],'firstofmonth')
Thank you so much! So easy, and yet I have been struggling for a few hours!
We've all been there, very welcome!
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