Notifications
Clear all
Topic starter
Is there a way to convert the date format to a date from the timestamp monsteracity within Select Expert?
Posted : May 27, 2014 9:51 am
What field are you trying to extract just the date from?
Table.Fieldname
Posted : May 27, 2014 10:33 pm
I believe you are trying to convert a DateTime to a Date. If so, you can use one of the following functions:
Date(DateTime) or
CDate(DateTime)
Date function can only be used in Crystal Syntax according to Crystal Help. You can search for Date in Crystal Help to get more information on these functions.
Hope this helps.
Posted : May 27, 2014 11:37 pm
Topic starter
Thanks..I am using select expert and the dates are in timestamp mode when I try to set up a date range parameter. Is there a way to have these in a date month day mode? Plz let me know if I need to explain more. thnx
Posted : May 28, 2014 1:32 am
I now got what you are looking for. I don't know how to do that. Usually I select the date from the calendar popup or I type the date in yyyy-mm-dd format.
Posted : May 28, 2014 1:42 am
I believe there is no easy way to change the format other than as explained by Brian in the link below.
Posted : May 28, 2014 2:03 am
Topic starter
Thank you, I will look at that.
Posted : May 28, 2014 2:27 am
