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.
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.