Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

Compare the UPDDATTIM to the current date.

Posted By Mike Dunkerley over 4 years ago

Hello,

I'm getting a Function Unknown Error 105 while trying to compare the UPDDATTIM to the current date.

If !clalev([F:BPC]) : Local File BPCUSTOMER [BPC] : Endif
Filter [F:BPC] Where format$("YYYYMMDD",[F:BPC]UPDDATTIM)= format$("YYYYMMDD",date$)
For [F:BPC]
Infbox(format$("YYYYMMDD",[F:BPC]UPDDATTIM))
Next
Filter [F:BPC]

-Mike

0 ChrisCC over 4 years ago

Why dont you use the UPDDAT field instead? Also your code is written badly....

If !clalev([F:BPC]) : Local File BPCUSTOMER [BPC] : Endif
For [F:BPC] Where [F:BPC]UPDDAT = date$
Infbox num$(format$("YYYYMMDD",[F:BPC]UPDDAT))
Next
Cancel
Vote Up -1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Dunkerley over 4 years ago in reply to ChrisCC

In this case, the UPDDAT was not being updated (by the BPCREDIT task). Mine code above was just to illustrate an example and not the final version.

-Mike
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

Compare the UPDDATTIM to the current date.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING