N Number11 Member Local time Today, 09:14 Joined Jan 29, 2020 Messages 625 Sep 28, 2022 #1 Hello, So i need to change the date format from 00/00/0000 to YYYYMMDD please can confirm the best way to convert this
Hello, So i need to change the date format from 00/00/0000 to YYYYMMDD please can confirm the best way to convert this
N Number11 Member Local time Today, 09:14 Joined Jan 29, 2020 Messages 625 Sep 28, 2022 #2 Sorted it.. Format(CDate(Format([DateField],"dd-mm-yyyy")),"yyyymmdd"
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 17:14 Joined May 7, 2009 Messages 20,727 Sep 28, 2022 #3 if it is a Real Date field, you can simplify it: Format([DateField], "yyyymmdd")
Gasman Enthusiastic Amateur Local time Today, 09:14 Joined Sep 21, 2011 Messages 17,483 Sep 28, 2022 #4 Why on earth are you formatting first to dd-mm-yyy and then to yyyymmdd ?
