Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Date format

Trading Post

Last Post by Anonymous 10 years ago

7 Posts

3 Users

0 Reactions

65 Views

RSS

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

joeg1962

(@joeg1962)

Posts: 843

Noble Member

What field are you trying to extract just the date from?

Table.Fieldname

Posted : May 27, 2014 10:33 pm

baj

(@baj)

Posts: 99

Estimable Member

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

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

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

baj

(@baj)

Posts: 99

Estimable Member

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

baj

(@baj)

Posts: 99

Estimable Member

I believe there is no easy way to change the format other than as explained by Brian in the link below.

http://scn.sap.com/thread/1867117

Posted : May 28, 2014 2:03 am

Anonymous

(@Anonymous)

Posts: 0

New Member Guest

Topic starter

Thank you, I will look at that.

Posted : May 28, 2014 2:27 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0