1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Can the date be in DD-MON-YYYY format in Excel using BI publisher

Discussion in 'Oracle Forms and Reports' started by SAGAR_GABA, Nov 30, 2012.

  1. SAGAR_GABA

    SAGAR_GABA Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    I am using XML data and with the help of BI publisher I am viewing the data in Excel. So excel automatically converts DD-MON-YYYY format into DD-MON-YY.So, is it a possibility that I could get the date in DD-MON-YYYY for date.






    Regards,

    Sagar
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Sagar,

    Don't know whether there is any standard process to overcome this issue. But what I did when this same issue comes is appended space at starting of that field at query level. So it was not in date field. So that we can overcome this problem.
     
  3. kalpesh

    kalpesh Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune, Maharashtra
    hi Sagar,

    MS Excel uses the default date,time format of your operating system. You can change your system default Date and Time setting from control panel. Set the default format as you wanted.
    There is nothing to do with your XML date format.

    Hopes this will resolve your problem.

    regards,
    kalpesh
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Kalpesh,

    That's fine we can change the format in system itself, but this solution was not good to suggest an user. So appended space to overcome this problem.
     
  5. kalpesh

    kalpesh Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune, Maharashtra
    hello bharat,

    I don't know why we need an extra space to overcome this problem...cause if you are converting huge data it will be very difficult to change the whole convention of date format.
    I was too facing the same problem but i resolved using simple trick...
    I've posted one problem related to R12 forms.
    please do have a look.
    am stuck i.e is of DATE related.
    Really appreciate if you have a look.

    Regards,
    kalpesh
     
  6. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Just by changing at query level by adding space we can convert all the date values. Rather than saying client to change the system date its easy to add that.. thats an simple idea behind it.

    Can please provide me that post link here..
     
  7. kalpesh

    kalpesh Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune, Maharashtra
    hi,

    How to raise an Error in R12 form.
     
  8. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Kalpesh,

    I do not understand what is raising an error. Do you want a pop message when an invalid value is entered ??

    For that write some validations in when-validate-item trigger and raise an alert or call message with relevant message.
    I hope I am clear from my side.

    If you want more details , please post the exact requirement
     
  9. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Kiran,

    Here is the link for exact requirement what he is looking for. Please have a look and update in that post kiran.

    Issue Link

    Yes we can go with personalization, but is there any way to do this while developing form itself.
     
    kiran.marla likes this.