Format current date as YYYYMMDD

Question

I need to format the current date as a string in format YYYYMMDD to use in a SQL query. Has anyone got this figured out? I tried to Google it but am not having much luck and I need this quickly.

Answer 1

I figured it out:

Format(Date(),"YYYYMMDD")

Answer 2

Hi AllTheGoodNamesWereTaken,

its good to hear that you have solve your issue by your self and you also posted your solution.

Thank you fro posting the solution so that if some other community member have a same issue like you then they can also get solution by your post.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.