# Toad Data Point Variable Output Format Issue

**URL:** <https://forums.toadworld.com/t/toad-data-point-variable-output-format-issue/49656>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [April 23, 2020, 4:05pm UTC](https://forums.toadworld.com/t/toad-data-point-variable-output-format-issue/49656 "2020-04-23T16:05:16Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![toad.user](https://avatars.discourse-cdn.com/v4/letter/t/e19b73/32.png) [@toad.user](https://forums.toadworld.com/u/toad.user)\
**Post date:** [April 23, 2020, 4:05pm UTC](https://forums.toadworld.com/t/toad-data-point-variable-output-format-issue/49656/1 "2020-04-23T16:05:16Z")

</div>

We're attempting to output some values to email using the set variable obj, but the format is not holding. Is there a method for formatting output within TDP when it doesn't pick up the format specified in a query?

SELECT  
Cast(Min(last\_login\_dt ) AS DATE) AS MinLoginDt  
,Cast(Max(last\_login\_dt) AS DATE) AS MaxLoginDt  
,Cast(Min(created\_dt) AS DATE) AS MinCreatedDt  
,Cast(Max(created\_dt) AS DATE) AS MaxCreatedDt  
,Cast(Min(registration\_dt) AS DATE) AS MinRegDt  
,Cast(Max(registration\_dt) AS DATE) AS MaxRegDt  
,Cast(Min(user\_created\_dt) AS DATE) AS MinUserCreateDt  
,Cast(Max(user\_created\_dt) AS DATE) AS MaxUserCreateDt  
,Cast(Min(user\_activation\_dt) AS DATE) AS MinUserActDt  
,Cast(Max(user\_activation\_dt) AS DATE) AS MaxUserActDt  
,Cast(Count(DISTINCT profile\_id) AS Format 'G999999999D99') AS DistinctID  
,Cast(Count(DISTINCT userid) AS Format 'G999999999D99') AS DistinctUser  
FROM db.table\_name

What we're looking for is commas for large ints and to remove the trailing timestamp since these are date values onlin.

This is what TDP is returning in the output. Why it returns a to\_date function in the output is an old problem we've seen that was never resolved in v5.0.

Distinct ID: 1678616  
Distinct User: 2737012

MinLoginDt: To\_date('08/06/2016 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MaxLoginDt: To\_date('08/06/2016 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MinCreatedDt: To\_date('02/02/2005 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MaxCreatedDt: To\_date('04/23/2020 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MinRegDt: To\_date('02/02/2005 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MaxRegDt: To\_date('04/23/2020 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MinUserCreateDt: To\_date('08/05/2016 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MaxUserCreateDt: To\_date('04/23/2020 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MinUserActDt: To\_date('08/06/2016 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')  
MaxUserActDt: To\_date('04/23/2020 00:00:00.00', 'MM/DD/YYYY HH24:MI:SS.SS')