Change month according to Current System Date (1 Viewer)

stonegold87

Member
Local time
Today, 19:10
Joined
Dec 10, 2020
Messages
37
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
 

CJ_London

Super Moderator
Staff member
Local time
Today, 14:10
Joined
Feb 19, 2013
Messages
16,553
not sure why you need a table, you can get monthname with

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

Users who are viewing this thread

Top Bottom