List of Date Format Conversions

Comments

5 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
  • Avatar
    Karen Rasnick

    Has anyone figured out how to convert account expiration date from Active Directory for a user?  

    0
    Comment actions Permalink

Please sign in to leave a comment.