Page 1 / 1
Hi,
Can you try running this:
to_date(<%=Year%>,FORMAT('%Y'))
But if you want to convert the whole date with month and day included, it should be:
to_date(<%=Year%>,FORMAT('%Y%m%d'))
You just have to add single quotes.
Hope this helps :)
Hi,
Can you try running this:
to_date(<%=Year%>,FORMAT('%Y'))
But if you want to convert the whole date with month and day included, it should be:
to_date(<%=Year%>,FORMAT('%Y%m%d'))
You just have to add single quotes.
Hope this helps :)
Hello Divya, I am so thankful for your answers, it helped me a lot. Sorry for the late reply, we were on a public holiday.
No Problem :)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.