Post reply

Default Year And Month

  • November 16, 2016 at 3:05 pm

    #332217

    Good Afternoon Guys,

    I would like to ask, how would I construct A Default Parameter named YearMonth(YYYYMM) from the current date in the system. could you show me how to put it in an expression?

    Best Regards,

    Noel

  • November 16, 2016 at 3:52 pm

    #1912931

    The expression below will do that.

    =Year(Now()) & Right("00" & Month(Now()),2)

  • November 17, 2016 at 8:42 am

    #1913114

    Much Thanks Sir, Worked Like a Charm

    Cheers!

    Noel

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply