hi
I have query with a calculate field to finds the next service due date but I'm having a problem getting it to only show services due dates in the next 30 days
for some reason I cant add a criteria date()-30
here's what I have to calculate the next service
it takes service intervals from maskservicemonths field then find the last service date and generates the next service due date
NextService: DateAdd("m",[MaskServiceMonths],[FindLast])
any ideas
thanks in advance
shane
I have query with a calculate field to finds the next service due date but I'm having a problem getting it to only show services due dates in the next 30 days
for some reason I cant add a criteria date()-30
here's what I have to calculate the next service
it takes service intervals from maskservicemonths field then find the last service date and generates the next service due date
NextService: DateAdd("m",[MaskServiceMonths],[FindLast])
any ideas
thanks in advance
shane