Date Time Month Calculation

ZoeM

Hello!

I have a data set where I would like to have a new field which changes based on the status of another field.

Ideally, I have a product and when the product is completed, a  completion date is provided e.g. 6/23/2022. I want a field that tells me whether the completion date falls within the current month i.e. all products that complete in June will say Yes and all others will say No. And when we move to July, same thing all over again. June products move to No and July completed products will be Yes. 

I know there is a Date time Month but I do not know how to construct this.  And I hope I have provided enough detail to summarize the outcome desired. 

Thanks!

Robin_McIntosh

Use  a formula like this.

if datetimemonth([DateTime_Out]) = DateTimeMonth(DateTimeToday())
then "YES"
else "NO"
endif

If you are looking for both current month and year then this formula:

if (datetimemonth([DateTime_Out]) = DateTimeMonth(DateTimeToday())
&& DateTimeYear([DateTime_Out]) = DateTimeYear(DateTimeToday()))
then "YES"
else "NO"
endif