Thanks Buddy. Hard to believe it's that easy. But it works! Thanks again. Bill ________________________________ From: [email protected] <[email protected]> on behalf of Buddy Walker <[email protected]> Sent: Saturday, March 27, 2021 6:56 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Date Conversion
Don’t use the () around the text Buddy Sent from my iPhone On Mar 27, 2021, at 5:50 PM, BILL MILYARD <[email protected]> wrote: Razzak: Thanks for you quick response. You're going to think I've lost my mind. I explained it backwards I want to convert a text to a date. vDate is TEXT and vServiceDate is DATE set var vServiceDate = (.vDate) Sorry, Bill ________________________________ From: [email protected] <[email protected]> on behalf of A. Razzak Memon <[email protected]> Sent: Saturday, March 27, 2021 4:45 PM To: [email protected] <[email protected]> Subject: Re: [RBASE-L] - Date Conversion Bill, Here's how: SET VAR vServiceDate TEXT = NULL SET VAR vServiceDate = (CTXT(.vDate)) That's all there is to it! Very Best R:egards, Razzak At 04:30 PM 3/27/2021, bmilyard wrote: >This should be easy but for some reason I can't get it to work. I >need to convert a date variable to a text variable. In my program >I'm setting a date to a text variable as: > >set var vServiceDate = (.vDate) >vServiceDate is a TEXT type and >vDate is a DATE type > >I've tried several Conversion, Date and String functions but none >work. I know I've done it in the past but can't hit on a >solution. What am I doing wrong? >Bill -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/0LfCve-1m1WV7166q-00olZl%40mrelay.perfora.net. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BLAPR10MB5345597A4A13CB1E5E84F514CB609%40BLAPR10MB5345.namprd10.prod.outlook.com<https://groups.google.com/d/msgid/rbase-l/BLAPR10MB5345597A4A13CB1E5E84F514CB609%40BLAPR10MB5345.namprd10.prod.outlook.com?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/32DB3AF0-6E74-4320-94F9-A0808404EF94%40comcast.net<https://groups.google.com/d/msgid/rbase-l/32DB3AF0-6E74-4320-94F9-A0808404EF94%40comcast.net?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BLAPR10MB5345AC960E388EC87D5F7064CB7F9%40BLAPR10MB5345.namprd10.prod.outlook.com.
