cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Question

A date stored in a source system is not a datetime that Sisense recognizes. Converting it to a Sisense datetime allows powerful front end capabilities (such as drill down, quick functions and more).

Answer

AddDays(CreateDate(1970,1,1), ((([Julian]- 210866803200000000) / 1000000)/86400))
CreateDate(2000+floor([JulianOracle]/1000)-100,GetMonth(AddDays(CreateDate(2016,1,1),Floor(mod([juliandate],1000)))),1)
or
AddDays(CreateDate(1900+([JulianOracle]/1000),1,1),ToInt(Right(ToString([JulianOracle]),3))-1)
Convert Text mm/dd/yy
CreateDate(

ToInt('20'+StrParts([date],'/', 3)),

ToInt(StrParts([date],'/', 1)),

ToInt(StrParts([date],'/', 2))

)
AddDays(CreateDate(1970,1,1), ([EPOCH DATE]/1000))
ToBigInt((DayDiff([date_field], CreateDate(1970,1,1)) * 86400))
Version history
Last update:
‎10-16-2021 07:06 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request