Using Max Date in Load Scripts

[Anonymous]

I am currently using this in my load scripts but would like to pull just the MAX Snapshot date??

WHERE([SNAPSHOT_CCYYMM])>='201701'

[Anil_Babu_Samineni]

May be this

WHERE [SNAPSHOT_CCYYMM] >= '201701';

[ahaahaaha]

Может быть, как это

WHERE [SNAPSHOT_CCYYMM] = Max (Date (Date# ([SNAPSHOT_CCYYMM], 'YYYYММ')));

[sunny_talwar]

May be like this

Table:

LOAD ....,

    [SNAPSHOT_CCYYMM]

FROM ....;

Right Join (Table)

LOAD Max([SNAPSHOT_CCYYMM]) as [SNAPSHOT_CCYYMM]

Resident Table;