Hi All,
I am trying to populate one of my target column by using below logic:
If (DUE_STLMT_DT + 2415021) > JulianDayFromDate(CurrentDate())
Then 'U'
Else If (DUE_STLMT_DT + 2415021)<=JulianDayFromDate(CurrentDate())
Then 'S' Else '' But the problem with above code is:
when the job runs midnight it is taking systemdate as current date,,but we need businessdate..
for ex:
if my job runs on 11:30pm on 15aug2007,it is giving 15aug2007 records because it is taking systemdateas current date
but if my job runs 12:30am on 16th it is giving 16aug2007 records
can any one help me to get actual businessdate records
how to implement to pick the records of my actual businessdate
in my above code..
BusinessDate vs SystemDate
Moderators: chulett, rschirm, roy
BusinessDate vs SystemDate
Thanx&Regards
scorpion
scorpion