I need to format date in yyyy.mm.dd
i have used:
DATA_MAX = Format(RS1.Fields(0).Value, "YYYY.MM.DD") (this RS! is 25/11/2013)
but the DATA_MAX return 0.00.0000
format date for Teradata
-
HansV
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: format date for Teradata
Are you sure that the first field is a date/time field? The code itself looks OK.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans