Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am attempting to stop a value loading based on a condition.
I have Two fields in my example
Article Number ; MovementDate
Article Number | Movement Date |
---|---|
001 | 2012.04.01 |
002 | 2012.05.01 |
003 | 2012.04.15 |
what i would to do is say if Article number has not been changed (connected to Movement Date) do not include in budget;
is a flag required first to mark the article as unmoved over the last year?
if so how is the code setup for this and if not how can one create a count statement based on this?
Best,
Bradley
Hi!
Try
Table:
Load *
From Table_Script
Where MovementDate > (dayend (Now(), -365 ))
Rebeca Gums
Hi!
Try
Table:
Load *
From Table_Script
Where MovementDate > (dayend (Now(), -365 ))
Rebeca Gums
HI Rebecca!
Thank you for your reply. It works perfectly.
If one were to use this in an expression however, could it be expressed as the following, I receive a syntax mistake when attempting to do this.
=if (Artikeltyp = 'z' and MovementDate > (dayend (Now (), -365)), ArticleNr;
It is brackets problem I have there.
Hi,
If my answer is that you need, please mark it as correct!
Rebeca Gums