Split a date field into YYYY-MM or YYYY format | Community
Skip to main content
Srinija_N
Srinija_N
Level 7
November 19, 2024
Solved

Split a date field into YYYY-MM or YYYY format

  • November 19, 2024
  • 2 replies
  • 920 views

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.
Best answer by Srinija_N

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/YY10/11/18atDate
MM/DD/YY Time10/11/18 12:00pmlongAtDate
MM/DD/YY10/11/18shortAtDate
Mth, DD, YROct, 11, 2018mediumAtDate
DW, Mth, Day, YRMon, Oct, 11, 2018partialAtDate
DW, Mth, Day, YR TimeMon, Oct, 11, 2018 12:00 pmfullAtDate

2 replies

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
November 19, 2024

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.

If this helped you, please mark correct to help others : )
Srinija_N
Srinija_NAuthor
Level 7
November 19, 2024

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

If this helped to solve your problem, please mark it as 'solved' so others can also find the solution faster. Thanks!
Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
November 19, 2024

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

 

If this helped you, please mark correct to help others : )
    Srinija_N
    Srinija_NAuthorAccepted solution
    Level 7
    November 19, 2024

    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/YY10/11/18atDate
    MM/DD/YY Time10/11/18 12:00pmlongAtDate
    MM/DD/YY10/11/18shortAtDate
    Mth, DD, YROct, 11, 2018mediumAtDate
    DW, Mth, Day, YRMon, Oct, 11, 2018partialAtDate
    DW, Mth, Day, YR TimeMon, Oct, 11, 2018 12:00 pmfullAtDate
    If this helped to solve your problem, please mark it as 'solved' so others can also find the solution faster. Thanks!
    Terms & ConditionsAccessibility statement

    Loading footer...