x Want to participate? Join the group to interact
Options
  • State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 56 subscribers
  • Views 638 views
  • Users 0 members are here
Browse Forums
Announcements
764
topics
17
replies
Financial year end
78
topics
177
replies
General Discussion UK
7k
topics
19k
replies
General Discussion Ireland
175
topics
311
replies
Install your software
138
topics
375
replies
Making Tax Digital
286
topics
692
replies
Manage your VAT
147
topics
321
replies
Protect and repair your data
44
topics
136
replies
Run your accounts remotely
85
topics
197
replies
Working with the bank
114
topics
292
replies
Josh B1234

ODBC Date Conversion

SUGGESTED
Posted By

Hi All,

Hopefully someone has dealt with this issue before

ODBC links are set up and usually work fine as lone as I don't use anything beyond SELECT, FROM, WHERE, AND, GROUP BY and ORDER BY

However, I want to convert a date field to "MM-YY" for a project I am working on, and no matter what I try I get an error saying "column not found" (cast,convert,format etc etc)

Does anyone have any tips?

Thanks and regards,

Josh

  • 0

    Hi Josh,

    Thanks for using Sage City.

    We don't support the ODBC links unfortunately but hopefully one of our forum members has some experience with this and can shed some light on it for you.

    I hope you manage to resolve this and if there's anything we can help with in the Sage 50cloud Accounts software, please don't hesitate to raise a new query.

    Kind regards,

    Sean,
    Sage UKI

  • 0
    SUGGESTED

    I'm afraid that functions such as cast,convert,format, etc are not implemented by the ODBC driver. The only supported way of achieving what you want would be to create a report in Report Designer where you can use various formatting options to manipulate the output.

*Community Hub is the new name for Sage City