if condition

[#1]

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

[#2 · Accepted solution]

Hi!

Try

Table:

Load *

From Table_Script

Where MovementDate > (dayend (Now(), -365 ))

Rebeca Gums

[#3]

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.

[#4]

Hi,

If my answer is that you need, please mark it as correct!

Rebeca Gums