on 06-02-2015 11:55 AM
Hi All,
Field1 is being fetched from database table using Database Look Up.
I have a condition
IF Field1(Type Time Point) is equal to blank(but it shows 01.01.0001)
THEN Field2 =N
ELSE Field2 = Y.
Now the field value in the databse table is blank and not 01.01.0001 so the above condition is failing in IF condition and jumping to ELSE condition.
Does BRFPlus not recongise the balnk field values or can recognise only blank timepoint value as 01.01.0001?
Appreciate quick help.
Thanks in advance
Hi,
In BRF+ date value 01.01.0001 is considered Initial as Blank is actually an invalid date value. But still you can use formula IS_INITIAL to check if date value is blank.
Consider the sample formula screenshot:
You should call this formula from your rule. You can't pass blank date in BRF+ simulation.
On the other hand, formula DT_IS_NULL returns TRUE if date is 01.01.0001.
Thanks,
Anindya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
As per your initial post, I understood that you pass a blank date (not 01.01.001) and you want to determine if date was blank. If that is the need then IS_INITIAL will work. It will return TRUE if the passed value is BLANK.
But now, you say that "value here being populated is 01.01.0001". So, you are passing 01.01.0001 and not a BLANK date.
In my previous post I also mentioned that "DT_IS_NULL returns TRUE if date is 01.01.0001".
So, please check DT_IS_NULL. May be you need to use both DT_IS_NULL and IS_INITIAL to check if DATE = BLANK or DATE = 01.01.0001.
Hope this helps. If yes, please mark as helpful.
Thanks,
Anindya
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.