slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Off Topic Forums - General & Off Topic
Forum for off topic and general discussion. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General & Off Topic | New Thread

View: Search:

Author

Thread: Orbis TaskCentre formatting issue

Kevin Austin
Posts: 105

Orbis TaskCentre formatting issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 07 3:51 AM

Hi all, I might be flogging a dead horse here but hopefully someone using this forum might use taskcentre. Basically its new to me and I've had a problem when inserting a date (from a field in a query) into an email (Send Message SMTP task), it formats as month/day/year and I want it to format in day/month/year format. I've used TO_DATE to format the date at query level but it still formats in the month/day/year format when the e-mail is sent out, please help!

Kev

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Orbis TaskCentre formatting issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 07 7:50 AM

Is this from a Query (using the query tool)?

If so, you need to make a change in your connection. Go into the connection at teh global level and go to teh SQL tab.. change the date format there.
I'd suggest you also contact the TaskCentre Certified Consultant that sold you TC and ask them teh question as well.. They should have been providing suypport to you.. you DID make a support arrangement with them.. didn't you?

--
rjl
(Also a TaskCenter Certified Consulting partner in NA

[Reply][Quote]

Kevin Austin
Posts: 105

Re: Orbis TaskCentre formatting issue Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 21 Jun 07 7:54 AM

Hi Bob,

Cheers for your response, I've sorted this now, I write pure SQL so I just formatted the date to a string within the statement to stop it changing the date format. Our support company is somewhat shocking so I thought I'd post it here as well because I tend to get more useful feedback

Kev

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 8:36:33 PM