Reformating a date

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
joftech
Posts: 117
Joined: Thu Oct 19, 2006 10:42 am
Location: Sydney
Contact:

Reformating a date

Post by joftech »

Hi Support

How would you do the following.

If I have a date formated and entered as 05/02/1961

How do I strip out the /

Thanks

Alan
aware_support
Posts: 7525
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Post by aware_support »

You can use REPLACE function to replace '/' symbols with nothing ''.
Aware IM Support Team
Post Reply