11 Replies Latest reply: Sep 17, 2015 9:13 PM by Yeo Poh sai

# How to make My Box 2 Display YrMthWk ?

Hi All

I have and field name = Data Type at Box 1 :-

Date Type, Column2

year,year

yr_jp,yr_jp

YrWk,YearWeek

YearQtr,YearQtr

YearHalf,YearHalf

Yr_Qtr_jp,Yr_Qtr_jp

YrMth,YearMonth

YrMthWk,YearMonthWeek

];

I have a Box 2 with below expression :-

=IF([Date Type]='year','Year',

IF([Date Type]='Yr','year',

IF([Date Type]='YrMth','Yr Mth',

IF([Date Type]='YearMonthWeek','YrMthWk',

IF([Date Type]='YearQtr','Yr Qtr'

)))))

My Question is why Box 2 not display YrMthWk ?

Paul

• ###### Re: How to make My Box 2 Display YrMthWk ?

It would be easier if you post your app,

Try do this

=IF([Date Type]='year',[Year],

IF([Date Type]='Yr',[year],

IF([Date Type]='YrMth',[Yr Mth],

IF([Date Type]='YearMonthWeek',[YrMthWk],

IF([Date Type]='YearQtr',[Yr Qtr]

)))))

• ###### Re: How to make My Box 2 Display YrMthWk ?

Hi All

Enclosed My QV Doc

• ###### Re: How to make My Box 2 Display YrMthWk ?

Try this

=IF([Date Type]='year',[Year],

IF([Date Type]='Yr',[year],

IF([Date Type]='YrMth',[YearMonth],

IF([Date Type]='YearMonthWeek',[YearMonthWeek],

IF([Date Type]='YearQtr',[YearQtr]

)))))

• ###### Re: How to make My Box 2 Display YrMthWk ?

Hi Clever

Thank you very much for your sharing.

I have try your propose script.

But it return wrong value.

I have enclosed my QV Doc.

Paul

• ###### Re: How to make My Box 2 Display YrMthWk ?

it seems to be working here

• ###### Re: How to make My Box 2 Display YrMthWk ?

Hi Clever

What I want is make Box 2 display 4 field from Box 1 .

I manage to display 3 field at Box 2. But I am unable to make field YearMonthDay display at Box 2.

Paul

Sent from my iPhone

• ###### Re: How to make My Box 2 Display YrMthWk ?

=IF([Date Type]='year',[Year],

IF([Date Type]='Yr',[year],

IF([Date Type]='YrMth',[YearMonth],

IF([Date Type]='YearMonthWeek',[YearMonthWeek],

IF([Date Type]='YearQtr',[YearQtr],

IF([Date Type]='yr_jp',[yr_jp],\$(=only([Date Type]))

))))))

• ###### Re: How to make My Box 2 Display YrMthWk ?

Hi Clever

Thank you for your reply. it still not get what i want. look like some thing wrong with my Doc. As some one also suggest the same script. also not work.

Paul

• ###### Re: How to make My Box 2 Display YrMthWk ?

Hi,

maybe this is what you need?

hope this helps

regards

Marco

• ###### Re: How to make My Box 2 Display YrMthWk ?

Hi Marco

Thank you for your sharing . May be my explaination is not clear , that is why so many people cannot understand.  I hope below image can make all understand.