Adobe Champion

Solved

Split a date field into YYYY-MM or YYYY format

5 replies
950 views
Translate All

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?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Srinija_NAccepted solution

Adobe Champion

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

Srinija N

Madalyn_Destafney

Community Advisor

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.

Translate

If this helped you, please mark correct to help others : )

Srinija_N

Author

Adobe Champion

There is no option to change the format in the advance options of the field. (May be due to the field is Standard)

Translate

Srinija N

Madalyn_Destafney

Community Advisor

Hm interesting. When you have the date field in a report column > advanced options > you should see this dropdown.

Translate

If this helped you, please mark correct to help others : )

Srinija_N

AuthorAccepted solution

Adobe Champion

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

Translate

Srinija N

Sign up

Login with SSO

Login to the community

Login with SSO