SimpleDateFormat() help....

[Exie]

Hi Folks,

I'm trying to genrate a date string like so:
[Time].[All Times].[FY2009].[Q2].[OCT].[10]

... so I'm trying to use the simple date formatter like so:
String formatter = new SimpleDateFormat("'[Time].[All Times].[FY'yyyy'].[Q1].['MMM'].['dd']'").format(new Date());

Here's my problem:
1. How can I calculate the quarter ? eg Q1 - Q4
2. How can I get FY2009 ? for OCT2008 ?
3. How can I get the month MMM to come out in all uppercase ?

 

[stefanwagner]

	{
		Date d = new Date ();
		String form1 = new SimpleDateFormat ("'[Time].[All Times].[FY'yyyy'].[#1][#2]['dd]").format (d);
		String mm    = new SimpleDateFormat ("M").format (d);
		int month = Integer.parseInt (mm);
		String q = "Q" + ((month+3)/4) + "]"; 
		String Mmm = new SimpleDateFormat ("MMM").format (d);
		String MMM = Mmm.toUpperCase ();
		System.out.println (form1.replaceAll ("#1", q).replaceAll ("#2", MMM));
	}

divide et impera.

don't visit my homepage:

http://home.arcor.de/hirnstrom/bewerbung