List of Date Format Conversions

Comments

4 comments

  • Avatar
    Andrew Block

    This will also work for Oracle (Julian):

    AddDays(CreateDate(1900+([JulianOracle]/1000),1,1),ToInt(Right(ToString([JulianOracle]),3))-1)

     

    2
    Comment actions Permalink
  • Avatar
    Justin Twohig

    Thanks Andrew! - added.

    0
    Comment actions Permalink
  • Avatar
    Lauren Allen

    What about adding timestamp to the epoch conversion for drill down to specific time of a transaction?

    0
    Comment actions Permalink
  • Avatar
    Karen Rasnick

    I used a combination of the above to convert my Julian Date.  However, it's adding one day to the result.  I tried changing the formula to substract  one day, the results appear correct with the exception of last day of the month which is returning no results.  Any suggestions to resolve this issue? 

    CreateDate(ToInt(Substring(ToString(GetYear(CreateDate(([Field]/1000),1,1))),1,4),GetMonth(AddDays(CreateDate(2016,1,1),Floor(Mod([Field],1000)))),GetDay(AddDays(CreateDate(2016,1,1),Floor(Mod([Field],1000))))-1)

    0
    Comment actions Permalink

Please sign in to leave a comment.