How to display the dates instead of having multiple dates field?

[gkcchowdary]

Hi

I have date field and dates like

5/25/2018 1:16:25

5/25/2018 1:15:35

5/25/2018 2:40:12

5/24/2018 12:15:15

5/24/2018 12:15:29

My requirement is I want to display only date with out time and display the single date only instead of multiple dates.

Like.  5/25/2018

          5/24/2018

Thanks

[Gysbert_Wassenaar · Accepted solution]

Cut off the time part using the floor function: Date(Floor(MyDate)) as MyDate

[gkcchowdary]

hi

Your solution working fine.

But I have one problem

If am using above expression .If I select any date after current selection box it showing number format.

Like 10 of 29437.

How display the dates  in current selection box.

[Gysbert_Wassenaar]

Cut of the time part of the date field in the load script. If you need the time parts then store those in a separate field.

[gkcchowdary]

Hi Gysbert

if get any idea on below requirement please help on this.

I want do in back end level(script)

target date changed count the ID's.

I have table fields

table:

Issu_ID

date_upload

Taget_date

-> KPI chart if the user selects any two dates compare those two dates.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.

Example:

Issue_ID      Date_upload      Target_date

01                01-01-2018           10-05-2018

01                03-01-2018           15-05-2018

02                01-01-2018           10-05-2018

02                03-01-2018           10-05-2018

03                01-01-2018           10-05-2018

03                03-01-2018           16-05-2018

In the above table if we select dates in the date upload field i.e., 01-01-2018 and 03-01-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.

so just count the Issues_ID when user select any two dates(ex:01-01-2018 is min date and 03-01-2018 is max date)compare those two dates if min date targetdate is onedate and max date targetdate is change to another date than caliculate the Issues_ID count.

I need quires for the above requirements in the back-end level.and write the expression front end level also if any simple way.

I have written quires in the front end level but the performance is slow and it is showing an error in the chart i.e., time out.

Thanking you.