Hello All,
In WebI Report, I have used the Date Object with time stamp. User wants to filter out with date only inside report on filter bar. While trying to doas below am getting with time stamp as well for all dates suffix 12:00AM. How can we ignore 12:00AM.
=ToDate(FormatDate([CreatedDate];“dd/MM/yyyy”);“dd/MM/yyyy”)
Regards,
Shravan
You could just leave off the ToDate function. The issue with that is then you have a string and the values will be in alphabetic order which will not be chronological order when you have data from multiple months (and years). You could format the date as follows…
=FormatDate([CreatedDate];"yyyy/MM/dd")
Then the alphabetic order will also be in chronological order.
Noel