Date Range filter time format changes
17 August, 2012
Hi,
When I set the default values for the date range filter by using the calender, before saving it shows date in format '2012-08-16 04:00:16'.
But as click on save it gets added milliseconds to this datetime format e.g. '2012-08-16 04:00:16.00'
So there�s no point in having the millisecond values I want to remove those from the default display.
Thanks,
Mentor
When I set the default values for the date range filter by using the calender, before saving it shows date in format '2012-08-16 04:00:16'.
But as click on save it gets added milliseconds to this datetime format e.g. '2012-08-16 04:00:16.00'
So there�s no point in having the millisecond values I want to remove those from the default display.
Thanks,
Mentor
Hi Mentor,
it is not possible to remove just the milliseconds from the datetime value from the calendar. The only way would be to change it to a date and thus get rid of the whole time component, though I'm not sure if that would suit your report or not.
Regards,
David
it is not possible to remove just the milliseconds from the datetime value from the calendar. The only way would be to change it to a date and thus get rid of the whole time component, though I'm not sure if that would suit your report or not.
Regards,
David
Hi Dave,
Is it possible to at least default the time to 00:00:00 instead of using the current time?
In most cases user want to query the entire day or data, without setting the time component.
Is it possible to at least default the time to 00:00:00 instead of using the current time?
In most cases user want to query the entire day or data, without setting the time component.
Hi David,
How do I change the datetime to a date?
Regards
Nikhil
How do I change the datetime to a date?
Regards
Nikhil
Hi Nikhil,
a datetime can be changed to a date using the Date Hierarchy feature of the View Builder.
Or alternatively it may done in a Virtual Table or Freehand SQL calculated field, of course you must know the specific function of your database to use.
Please let us know if you need further direction in achieving this.
regards,
Dave
a datetime can be changed to a date using the Date Hierarchy feature of the View Builder.
Or alternatively it may done in a Virtual Table or Freehand SQL calculated field, of course you must know the specific function of your database to use.
Please let us know if you need further direction in achieving this.
regards,
Dave