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

The Problem

Date information from the source is represented as an integer, with the format YYYYMMDD. We need the information to be represented as a date-time data type in Sisense. 

The Solution

This will utilize a custom field to convert the value. The original date value needs to be defined in the ElastiCube as an integer data type. The following code gets the correct results:
ToInt(Substring(ToString([Date Num]),1,4)),
ToInt(Substring(ToString([Date Num]),5,2)),
ToInt(Substring(ToString([Date Num]),7,2))
Version history
Last update:
‎02-07-2024 01:18 PM
Updated by:
Community Toolbox

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

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: