Need to excludes values on date field

[nevilledhamsiri]

Hi!

Please check my loaded data of which month/year field takes value. How calculated dimension be applied to correct this as this goes as a dimension field!. Also appreciate if steps are properly laid down to correct through  number tab!

Thanks

Neville

      Excel used

BRANCH	MONTH/YEAR	MOTOR	NON_MOTOR	TOT_PREMIUM
RA	January-16	100,000	250000	350,000
RA	February-16	250,000	300000	550,000
RA	March-16	350,000	150000	500,000
RA	April-16	450,000	350000	800,000
RA	May-16	500,000	250000	750,000
RA	June-16	583,333	150000	733,333
RA	July-16	658,333	200000	858,333

[Frank_Hartmann]

whats the expected output?

please give some more precise information about what you want to achieve!

[its_anandrjs]

Share some sample data to have a look may be you ask for date field.

[vishsaggi]

Correct me are you trying to display your MonthYR as of Excel format like Jul-2016?

May be use this in your calculated dim:

= Date(YourMonthYrField, 'MMM-YYYY')

[nevilledhamsiri]

Dear Vishwarath,

Thanks, Your expression for date calculation did work! Does this treatment correct the value shown on the date field already loaded. It seems no. In fact it is the format what you suggested I had used. Like this(March-12). Please advice me on,

Isn't it possible to to adjust the date format on already loaded data?

Like what you propose   = Date(YourMonthYrField, 'MMM-YYYY'), please rewrite all other formats so that I can use them later!

Thanks

Neville

[nevilledhamsiri]

Dear Vishwarath,

This is how it appears!

[vishsaggi]

You can have many different formats for the Date field. What format you are looking for? And what is the expression you are using for your Date.

= Date(YourdateField, 'DD/MM/YYYY')

OR

= Date(YourdateField, 'MM/DD/YYYY') something like that.

[nevilledhamsiri]

What about the already loaded field. Can it be  converted to the same format or need to omit & use the date field made through the expression?

[vishsaggi · Accepted solution]

You can use the Date() function even though it is already have a loaded datefield. So Just use the date function on your datefield which you have already loaded. What format you want and what is the date field name.

= Date(youralreadyloadeddatefield, 'yourformat here')

[nevilledhamsiri]

Thanks Wishwanath very much. I will close the thread!

Neville