Change month according to Current System Date

[stonegold87]

Dear All!
I need help from all experts
i have Month Table (MonthID, MonthName)
I want to change MonthID in another form combo box
Like if current date is Ist Jan to 31st Jan (Month ID Is 1)
if Current Date changes to 1st Feb (MonthID should change to 2)
Regards

 

[Gasman]

=Month(Date)

 

[CJ_London]

not sure why you need a table, you can get monthname with

=format(date,"mmmm") for January or =format(date,"mmm") for Jan