Split a date field into YYYY-MM or YYYY format

[Sri_Nijs]

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?

[Madalyn_Destafney]

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.

[Sri_Nijs]

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

[Madalyn_Destafney]

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

 

[Sri_Nijs]

Even I felt weird when I didn't see these options for the date formats, So I had to go with the text mode. 

Thanks Anyway  

[Sri_Nijs · Accepted solution]

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