OraFAQ Forum: Reports & Discoverer » Using Instr and substr

Home » Developer & Programmer » Reports & Discoverer » Using Instr and substr (BIP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using Instr and substr [message #601664]

Sat, 23 November 2013 21:36

purnimagn
Messages: 2
Registered: November 2013
Location: Bangalore

Junior Member

Hi,

I am trying to use the same logic you mentioned, but with the Instr withing the substring. My date format is d/m/yyyy.
The code I have written is
<?xdofx:substr(SsCalculatedArrivalDate,Instr(SsCalculatedArrivalDate,'/',1,2)+1,Instr(SsCalculatedArrivalDate,'/',1,2)+4) || '-' || substr(SsCalculatedArrivalDate,Instr(SsCalculatedArrivalDate,'/',1,1)+1,Instr(SsCalculatedArrivalDate,'/',(Instr(SsCalculatedArrivalD ate,'/',1,1)+1),2)- (Instr(SsCalculatedArrivalDate,'/',1,1))) || '-' || substr(SsCalculatedArrivalDate,1,Instr(SsCalculatedArrivalDate,'/',1,1)-1)?>

which returns me the date in the yyyy-m-d format, but I cant use the word properties to display it in dddd, MMMM dd, yyyy, but it always displays in yyyy-m-d.

Please help.

Thanks

Report message to a moderator

Re: Using Instr and substr [message #601747 is a reply to message #601664]

Mon, 25 November 2013 04:33

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

purnimagn wrote on Sun, 24 November 2013 03:36

Hi,

I am trying to use the same logic you mentioned, but with the Instr withing the substring.

Who mentioned it where? We have no cluse what you are referring to.
purnimagn wrote on Sun, 24 November 2013 03:36

My date format is d/m/yyyy.

The date format of what exactly?

purnimagn wrote on Sun, 24 November 2013 03:36

which returns me the date in the yyyy-m-d format, but I cant use the word properties to display it in dddd, MMMM dd, yyyy, but it always displays in yyyy-m-d.

I have no idea what you mean by word properties.

Report message to a moderator

Previous Topic:	Convert report to Excel
Next Topic:	Convert report to Excel File

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 00:48:09 CST 2024