how to convert a period field into yyyy/mm

[#1]

hi all

i have below  field  is like that i need change as yyyy/mm kindly plz help me to find correct solution for the problem

[hytown2000 · Accepted solution]

You may use expression like this,

Date(Date#(Period, 'YYYYMM'), 'YYYY/MM')

[MK9885]

If that's an XL file then

Select your dates>Right click>Format Cells>Custom>Select any value and Type YYYY/MM>Ok

Again select all dates>click on the ! icon on the left>Convert to XX to 20XX

[#4]

thank u Tommy

[#5]

Hi Kowsik,

You can use MakeDate(Year,Month,01) as Period

~ Ravi Kancharla

[#6]

Thank you Ravi

[Lech_Miszkiewicz]

Hi All,

Keep in mind that this will be still kept as a separate date for each day of month so to convert it to month-year value you will have to use something like:

Date(MonthStart(Date#(Period, 'YYYYMM'), 'YYYY/MM')))

then when you use this column in listbox you will fin one instead of 28,29 or 30-31 the same looking values in each month.

regards

Lech