Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
i want to get the current month in two digits. (01,02,03,04,05,06,07,08,09,10,11,12)
i need a expression - but without an IF.
can someone help?
num(MonthField, '00')
num(MonthField, '00')
Hi
what if I have 2 digits month number and i want month name?
Date(Date#([Month Number], 'MM'), 'MMM')
or
Pick(Match([Month Number], '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12'),
'January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December')