DateAdd

[Gismo]

Hi all
i did not expect to have an error when using the function builder
maybe im am not understanding the function
a need to add 12 month to my date field
below is my query
please could you assist

 

[bastanu]

Enclose the m in double-quotes: DateAdd("m",12,[AMPDate])
Cheers,
Vlad

 

[Gismo]

Enclose the m in double-quotes: DateAdd("m",12,[AMPDate])
Cheers,
Vlad

Originally I had the double quotes, still no luck

 

[Gismo]

Go it tnx, seems like spaces makes a big difference

 

[theDBguy]

Go it tnx, seems like spaces makes a big difference

Hi. Would you mind showing us the final version that worked? Thanks!

 

[Gasman]

Go it tnx, seems like spaces makes a big difference

I don't think so?

? dateadd("m", 12, Date)
07/04/2021

 

[Gismo]

I don't think so?

? dateadd("m", 12, Date)
07/04/2021

yeh you right,
made no difference, no sure why i received an error but is works nowtnx all