Forum Discussion

DarleneDarlene's avatar
DarleneDarlene
Qrew Member
11 years ago

Can I display a date field as YYYY-MM, where MM would be a two-digit rendering for the month?

I'd like a field to look at a specific date entered, and then return the year/month in the following format: YYYY-MM, where MM would be two-digit rendering of the month. For example, 1/15/14 would r...
Forms
Formulas and functions
Tables and fields
MarkShnier's avatar
MarkShnier
Qrew Trainee
11 years ago
No problem, Try this

var text YYYY = Totext(Year([SLA Date:]));

var text MM = right("0" & totext(Month([SLA Date:]),2);

$YYYY & "-" & $MM)


This trick is to zero pad the month, so you stick on a leading zero and then take the rightmost 2 characters.

so, 0 becomes 01 and 12 becomes 012 which gets trimmed to 12 when you take the rightmost 2 characters.