date format

Sage 50 general help forum - Free help and support for all general issues
Post Reply
sageNoob
User
User
Posts: 106
Joined: 03 Aug 2020, 12:04
Sage Version: v2015 21 UK/Europe/Africa

date format

Post by sageNoob » 13 Nov 2022, 20:26

Hello,

Do we have any way to find out the month or year from the date in microsoft query.

Example: 2022-10-28 We need to display only 2022

Thanks
Neha
Top
User avatar
brucedenney
Site Admin
Site Admin
Posts: 4633
Joined: 28 Feb 2006, 09:56
Sage Version: v28 UK/Europe/Africa

Re: date format

Post by brucedenney » 14 Nov 2022, 10:44

Not in query, but once you have the data in Excel/Acces or whatever yo could then manipulate it.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Top
Post Reply

Return to “Sage 50 UK version General Help”

Who is online

Users browsing this forum: No registered users and 1 guest