date format

[Former Member]

Hi,

I am getting date in text format as 20080130 . i want to get the value as 30.01.2008. I am using the follwoing formatting in customs dstr(@changed_on_key,'dd.mm.yyyy') but its nt working. No data is shown for this format in table..Where i am getting wrong??

Thanks

Prashant

[Former Member]

Try getting the different date elements from your string something like this:

DATE(MID(@changed_on_key,1,4),MID(@changed_on_key,5,2),MID(@changed_on_key,7,2))

This constructs a year, month, day date format that you most probably can format to what you want.

You probably have to fiddle around with the formula editor to get it exactly like you want.

Good luck

Henning Strand

[Former Member]

Hi Prashant,

you can do it like Henning has described or by using other formulas with right and left function.

Best Regards,

Marcel

[Former Member]

Hi

I used DSTR(DATE(MID(@changed_on_key,1,4),MID(@changed_on_key,5,2),MID(@changed_on_key,7,2)),'DD.MM.YYYY')....Using this the date value changes from 20080130 to 1980.12.02.. ...what can be format to get 30.01.2008

Thanks

Prashant

[Former Member]

Hi,

Infact the date format is 30.01.2008 in cube and its shown in same format in bex but its chancging in VC

what can b done??

Thanks

Prashant

[Former Member]

Hi Prashant,

Did you manage to resolve this issue?

I am getting the following format in VC "Sat Mar 20" and would like it to be "Saturday 20 March 2010" - can you help?

Thanks,

Bim.