Formula Help

[erhan_79]

Hi there ;

i need your support about creating below formula , let me explain ps what i need ;

i have table as below and i have "creation date"  column , i would like to create a new column which one 's name is " Month Data" , i want that the new column will work like that ;

Scenario : 

TODAY = 17.06.2020 and   Month is June 

Rules : 

if the "creation date"   includes before dates than today  ; " Month Data "  will seem   " Actual Month".

İf the "creation date"  is  equal to today  ;  " Month Data "  will seem   " Actual Month".

İf the "creation date " is after than today but includes June days ;   " Month Data "  will seem   " Actual Month".

İf "creation date"  is after than today but  not includes  June days    ; " Month Data "  will seem   " Next  Month".

[amitchandak · Accepted solution]

@erhan_79 , a new column like

if([creation date] <eomonth(today(),0),"Actual Month","Next Month")

[amitchandak · Accepted solution]

@erhan_79 , a new column like

if([creation date] <eomonth(today(),0),"Actual Month","Next Month")

[erhan_79]

dear @amitchandak  ;

now i noticed something when the creation date is last day of the month , on new column it writes "next month " too , but infact it must write " actual month " for 30.06.2020 too.Could you pls check it too 

[amitchandak · Accepted solution]

Make < as <=

[created date] <= eomonth(today(),0)

[erhan_79]

thanks @amitchandak 

now everything is ok 

[erhan_79]

---

---

dear @amitchandak  ;

thank you very much , it is working very well , you always help us thanks for your kind supports