Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am loading multiples xls files, with *.xls, and i have multiples formats of date. But, i can not use
date#(RENEWAL_DATE,'M/D/YYYY''YYYYMMDD'). I tried with , and ; between, but it says that date# takes only 2 parameters. How can i make to use date# for multiples formats?
Thank you,
Cosmina
You could use alt() to check of various different formattings like:
alt(date#(RENEWAL_DATE,'M/D/YYYY'), date#(RENEWAL_DATE,'YYYYMMDD'))
- Marcus
Check below blog posts...
Check Page 7 of below..
You could use alt() to check of various different formattings like:
alt(date#(RENEWAL_DATE,'M/D/YYYY'), date#(RENEWAL_DATE,'YYYYMMDD'))
- Marcus