General OBIEE

Get Involved. Join the Conversation.

Topic

    Sara Simpson
    Removing time from date criteriaAnswered
    Topic posted March 16, 2015 by Sara SimpsonSilver Medal: 2,000+ Points, tagged OBIEE Answers, Reports 
    1131 Views, 10 Comments
    Title:
    Removing time from date criteria
    Content:

    In all criteria the date appears as 03/03/2015 03:56:13 PM. Is there anyway to remove the timestamp from the view so only the date appears in the columns?

    Thanks!

    Sara

    Image:

    Best Comment

    Julian Challenger

    Comment

     

    • Julian Challenger

      You can format the data format using the column properties on the first tab.

      • Sara Simpson

        Thanks - I already have tried this, but all the options in 'Date Format' do have the time included. I also tried Custom but it didn't work. Perhaps I am missing a step or something?

    • Julian Challenger

      Check "Override Default Data Format", keep "Date Format"=Custom and then enter your format into the "Custom Date Format" field.  I often use dd-MMM-yyyy which gives me 16-Mar-2015, a format that is generally understood throughout the world.  Finally, click OK and it should work.

    • Jason McWatts

      Hi Sara

      Have you tried click on 'Data Format' tab in the column properties, ticking 'Override default data format', selecting 'Custom' as the date format and then typing the custom date format as dd/MM/yyyy? i.e. just removing the HH:mm from the format.

      Jason

    • Julian Challenger

      You can also change the date format in Fusion in "Set Preferences" > "Regional".  After a little while, the format you chose should be applied in Answers.

    • Stephanie Gott

      Additional question regarding this issue:

      Beyond just formatting, is there a way to actually restate the column so that is actually just a date? The data formatting is just cosmetic. I'm trying to do a Case statement on 2 date columns. When one is >= another, then I want it to show as "overdue". The problem is that it is taking the time into consideration. So if the dates are the same but the time is later than the other, it is showing as overdue when really I don't want it to (the business has until EOB to complete work).

      Any thoughts on how to do this?

      Thanks,

      Stephanie

    • Stephanie Gott

      Additional question regarding this issue:

      Beyond just formatting, is there a way to actually restate the column so that is actually just a date? The data formatting is just cosmetic. I'm trying to do a Case statement on 2 date columns. When one is >= another, then I want it to show as "overdue". The problem is that it is taking the time into consideration. So if the dates are the same but the time is later than the other, it is showing as overdue when really I don't want it to (the business has until EOB to complete work).

      Any thoughts on how to do this?

      Thanks,

      Stephanie