DatePart

C

Charlie

I'm converting an Access frontend to adp. I use the
format function in update queries to allow the eu to
select different report periods and me to only have one
report. ie
UPDATE tblZHold
SET Field7 = Format([Fdate],'yyyy'),
Field8 = Format([Fdate],'mm'),
FT4 = 'Month',
FT5 = Format([Fdate],'mmm-yyyy');

I figured out the format function is not allowed in adp.
I tried using the DATEPart Function but can't get it to
work. Can DatePart be used in an Update SP? If not any
suggestions on alternatives. Thanks in advance.
 
Top