I have tried many times but not succeed, I have pick up date as text 20171020
When I use isdate function it recognize as date shows 1
I want to covert this date to 10/20/2017
Kindly help me out . Thanks in advance.
SELECT
I have tried many times but not succeed, I have pick up date as text 20171020
When I use isdate function it recognize as date shows 1
I want to covert this date to 10/20/2017
Kindly help me out . Thanks in advance.
SELECT
Along the lines of:
DateSerial(Left(FieldName, 4), Mid(FieldName, 5, 2), Right(FieldName, 2))
Look at this video and see if you can do what you need after watching it.
http://www.datapigtechnologies.com/f...anipulate.html
Also the mid function is an Access function. Look at this link
https://www.techonthenet.com/access/...string/mid.php
This is a query built in Access query designer? Not a query in SQLServer or MySQL or T-SQL? Will Right() work - test it by itself.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Oh, I missed that this was in SQL Server forum. If in T-SQL simply:
convert(date,FieldName)
In a test:
select convert(date,'20171020')
returned
2017-10-20