Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#54194 - 01/07/20 12:55 AM Changes date AP Check
joi
Member


Registered: 06/09/09
Posts: 68
Loc: Philippines
I have a problem about changes of date in our check for printout
This is our existing formula:
//totext({BKREG.CHKDATE},"00000000"))
pwformatdate({BKREG.CHKDATE})

//MID(TOTEXT({BKREG.CHKDATE}),5,2) + "/" + MID(TOTEXT({BKREG.CHKDATE}),7,2) + "/" + MID(TOTEXT({BKREG.CHKDATE}),1,4)

My problem is I wanted to change the date sample from January 07, 2020 to 01-07-2020. I'm only a beginner in this formula. I hope you can help me in this simple formula.
Thank you
_________________________
joi

Top
#54195 - 01/07/20 04:36 AM Re: Changes date AP Check [Re: joi]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7760
Loc: Location, Location
Use the PWFormatDate function
_________________________
Jay Converse
Sage 300 Whisperer

Top
#54196 - 01/07/20 03:57 PM Re: Changes date AP Check [Re: Jay Converse]
Ettienne
Member


Registered: 06/28/02
Posts: 3675
Loc: Orlando, Florida USA
Right click the date field on the report, Format Field, Date and set the required date format.
_________________________
Sage 300 ERP Certified Consultant

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: