Capture specific Date

[Ayden]

Hello I have data that contains Balance amount which changes daily. I would like to capture the balance amount at the end of each month. Such as a snapshot date or something.

Data looks like this

LOAD

PART,

POSTINGPERIOD,

FINANAICAL FISCAL YEAR,

QTY,

BALANCE AMOUNT 

FROM XYZ(

[sidhiq91]

@Ayden  First you can create a variable

Let Vmonthend = Monthend(Today());

Then in your Load Script you can use the variable something like below:

LOAD

PART,

POSTINGPERIOD,

FINANAICAL FISCAL YEAR,

QTY,

BALANCE AMOUNT 

FROM XYZ

Where POSTINGPERIOD='$(Vmonthend )';

If this resolves your issue, please like and accept it as a solution.