N Number11 Member Local time Today, 04:11 Joined Jan 29, 2020 Messages 624 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, 04:11 Joined Jan 29, 2020 Messages 624 Sep 28, 2022 #2 Sorted it.. Format(CDate(Format([DateField],"dd-mm-yyyy")),"yyyymmdd"
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 11:11 Joined May 7, 2009 Messages 20,630 Sep 28, 2022 #3 if it is a Real Date field, you can simplify it: Format([DateField], "yyyymmdd")
Gasman Enthusiastic Amateur Local time Today, 04:11 Joined Sep 21, 2011 Messages 17,424 Sep 28, 2022 #4 Why on earth are you formatting first to dd-mm-yyy and then to yyyymmdd ?
P Pat Hartman Super Moderator Staff member Local time Yesterday, 23:11 Joined Feb 19, 2002 Messages 48,208 Sep 28, 2022 #5 Use arnel's suggestion. Remember formatting dates is for human consumption or in this case, I'm assuming that you are formatting the date so you can use a query to export it to a different application.
Use arnel's suggestion. Remember formatting dates is for human consumption or in this case, I'm assuming that you are formatting the date so you can use a query to export it to a different application.