Split a date field into YYYY-MM or YYYY format

Question

I have a date field in the general format MM-DD-YYYY. Now I need two new fields out of it in YYYY-MM and YYYY format. Can this be done via text mode view?

Srinija_N · Accepted Answer

I was able to find the text mode by myself anyway.

YYYY/MM:

valueexpression=CONCAT(YEAR({lastLoginDate}), '/', MONTH({lastLoginDate}))

YYYY format:

valueexpression=YEAR({lastLoginDate})

and also found the below for any other formats.

Format Example valueformat=

MM/DD/YY	10/11/18	atDate
MM/DD/YY Time	10/11/18 12:00pm	longAtDate
MM/DD/YY	10/11/18	shortAtDate
Mth, DD, YR	Oct, 11, 2018	mediumAtDate
DW, Mth, Day, YR	Mon, Oct, 11, 2018	partialAtDate
DW, Mth, Day, YR Time	Mon, Oct, 11, 2018 12:00 pm	fullAtDate

Madalyn_Destafney · Answer

Are you wanting to show the date fields in columns in a report? If so, you pull in the date field into your column and then in the advanced options of that column, you can select how you want the date field to appear/format.

Sign up

Login with SSO

Login to the community

Login with SSO