SageForum for UK versions of Sage 50- Help and support.

Help and support for Sage50 users, covering all subjects including report writing, installation problems, accounting issues, data errors, integrating with other desktop systems and web services..
https://forum.makingithappen.co.uk/

date format

https://forum.makingithappen.co.uk/viewtopic.php?t=4334

Page 1 of 1

date format

Posted: 13 Nov 2022, 20:26
by sageNoob
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

Re: date format

Posted: 14 Nov 2022, 10:44
by brucedenney
Not in query, but once you have the data in Excel/Acces or whatever yo could then manipulate it.
All times are UTC
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited