DateAdd (1 Viewer)

Gismo

Registered User.
Local time
Today, 06:59
Joined
Jun 12, 2017
Messages
438
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
1586274576282.png
 

Attachments

bastanu

Registered User.
Local time
Yesterday, 20:59
Joined
Apr 13, 2010
Messages
372
Enclose the m in double-quotes: DateAdd("m",12,[AMPDate])
Cheers,
Vlad
 

Gismo

Registered User.
Local time
Today, 06:59
Joined
Jun 12, 2017
Messages
438
Enclose the m in double-quotes: DateAdd("m",12,[AMPDate])
Cheers,
Vlad
Originally I had the double quotes, still no luck

1586276152832.png
 

Gismo

Registered User.
Local time
Today, 06:59
Joined
Jun 12, 2017
Messages
438
Go it tnx, seems like spaces makes a big difference
 

Gismo

Registered User.
Local time
Today, 06:59
Joined
Jun 12, 2017
Messages
438
I don't think so?

Code:
? 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
1586280041264.png
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom