K
knitter via AccessMonster.com
Hi Group,
I'm using this code from John Vinson (many thanks for that) and it's working
very well:
DueDate: DateAdd(Switch([Frequency] = "Annual", "yyyy", [Frequency] =
"Monthly", "m", [Frequency] = "Weekly", "ww"), 1, [CompletedDate])
However, my Frequency field contains Semi-Annual and Bi-Monthly also. I can't
get the syntax right to include those frequency types. I tried using
"Monthly", "m",6, but I got an error. Do I need to enclose that in
parenthesis maybe?
Can anyone help?
I'm using this code from John Vinson (many thanks for that) and it's working
very well:
DueDate: DateAdd(Switch([Frequency] = "Annual", "yyyy", [Frequency] =
"Monthly", "m", [Frequency] = "Weekly", "ww"), 1, [CompletedDate])
However, my Frequency field contains Semi-Annual and Bi-Monthly also. I can't
get the syntax right to include those frequency types. I tried using
"Monthly", "m",6, but I got an error. Do I need to enclose that in
parenthesis maybe?
Can anyone help?