Date Format 1

[craigward]

Hi,

I have a date that i need to format like yyyy/mm/dd but i can't find anything of that on the internet. currently the code below does what i need and takes today's date and adds 1 month to it. Problem is SQL does'nt like the format so i need to change the result from dd/mm/yyyy to yyyy/mm/dd

Any ideas on doing that? Thanks in advance.

dateplusmonth = DateAdd("m",1,date())

 

[PHV]

You may use this:
Year(dateplusmonth) & "-" & Month(dateplusmonth) & "-" & Day(dateplusmonth)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[craigward]

Great help thank you!