According to the Tokens you can use to parse a date variable, you can use dddd, D MMMM, YYYY. e.g.: {{ parseDate(date; "dddd, D MMMM, YYYY") }} After parsing the date correctly, only then you can use formatDate e.g.: {{ formatDate(parseDate(date; "dddd, D MMMM, YYYY"); "DATE-FORMAT") }} Links He… Answer from samliew on community.make.com
🌐
Microsoft Learn
learn.microsoft.com › en-us › sql › t-sql › functions › cast-and-convert-transact-sql
CAST and CONVERT (Transact-SQL) - SQL Server | Microsoft Learn
Starting with GETDATE() values, this example displays the current date and time, uses CAST to change the current date and time to a character data type, and then uses CONVERT to display the date and time in the ISO 8601 format.
🌐
W3Schools
w3schools.com › sql › func_sqlserver_convert.asp
SQL Server CONVERT() Function
String Functions: ASCII CHAR_LENGTH ... SEC_TO_TIME STR_TO_DATE SUBDATE SUBTIME SYSDATE TIME TIME_FORMAT TIME_TO_SEC TIMEDIFF TIMESTAMP TO_DAYS WEEK WEEKDAY WEEKOFYEAR YEAR YEARWEEK Advanced Functions: BIN BINARY CASE CAST COALESCE CONNECTION_ID CONV CONVERT CURRENT_USER DATABASE ...
Discussions

How do you convert date format to another?
u/InstaMastery - Your post was submitted successfully. Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread. Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. Include your Excel version and all other relevant information Failing to follow these steps may result in your post being removed without warning. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
🌐 r/excel
10
1
December 22, 2021
java - How do I convert the date from one format to another date object in another format without using any deprecated classes? - Stack Overflow
I'd like to convert a date in date1 format to a date object in date2 format. More on stackoverflow.com
🌐 stackoverflow.com
Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes ... More on community.smartsheet.com
🌐 community.smartsheet.com
October 3, 2024
Convert date to specific format
Hi everyone i will get the input form excel sheet and i need to modify the date formates and write back to excel how can i do that Example Input : 22-aug-2022 and more like this. But, i need as output of this “dd.MM.yyyy”. This format. More on forum.uipath.com
🌐 forum.uipath.com
1
0
August 29, 2023
🌐
Reddit
reddit.com › r/excel › how do you convert date format to another?
r/excel on Reddit: How do you convert date format to another?
December 22, 2021 -

I have thousands of dates in a sheet that is formatted yyyymmdd Example: 20220827 for August 27, 2022.

I’d like to convert it from yyyymmdd to m/d/yyyy (or mm/dd/yyyy) with the slashes. How do I re-format this for all cells?

🌐
Longpela Expertise
longpelaexpertise.com.au › toolsJulian.php
Julian Date Converter - Longpela Expertise
Today's date is 15-Mar-2026 (UTC). Today's Julian Date is 26074 · We refer to a yyddd date format (yy = year, ddd=day) as a 'Julian Date' - this is the common term for such a date in mainframe and other circles. However technically, a Julian date can mean different things.
🌐
YouTube
youtube.com › watch
CHANGE DATE FORMAT in Excel | Convert to CORRECT DATE, Abbreviate Dates - YouTube
Learn how to change the date format in Excel to suit your needs perfectly! This comprehensive tutorial will guide you through how to change a date format in ...
Published   May 29, 2024
Views   8K
Find elsewhere
🌐
MSSQLTips
mssqltips.com › home › sql date format examples using convert function
SQL Date Format Examples using SQL CONVERT Function
September 26, 2025 - DECLARE @Datetime DATETIME; SET @Datetime = GETDATE(); --yyyy mm dd with 4 DIGIT YEAR SELECT REPLACE(CONVERT(VARCHAR(10), @Datetime, 102), '.', ' ') CurrentDateFormattedAsText; --yy mm dd with 2 DIGIT YEAR SELECT REPLACE(CONVERT(VARCHAR(8), @Datetime, 2), '.', ' ') CurrentDateFormattedAsText; -- pull data from a database table -- The date used for this example was January 15, 2013. --SELECT a datetime column as a string formatted yyyy mm dd (4 digit year) SELECT TOP 3 REPLACE(CONVERT(CHAR(10), ExpectedDeliveryDate, 102), '.', ' ') ExpectedDeliveryDateFormattedAsText FROM Purchasing.PurchaseOrders WHERE OrderDate < @Datetime; --SELECT a datetime column as a string formatted yy mm dd (2 digit year) SELECT TOP 3 REPLACE(CONVERT(CHAR(8), ExpectedDeliveryDate, 2), '.', ' ') ExpectedDeliveryDateFormattedAsText FROM Purchasing.PurchaseOrders WHERE OrderDate < @Datetime;
Top answer
1 of 10
155

Use SimpleDateFormat#format:

DateFormat originalFormat = new SimpleDateFormat("MMMM dd, yyyy", Locale.ENGLISH);
DateFormat targetFormat = new SimpleDateFormat("yyyyMMdd");
Date date = originalFormat.parse("August 21, 2012");
String formattedDate = targetFormat.format(date);  // 20120821

Also note that parse takes a String, not a Date object, which is already parsed.

2 of 10
14

tl;dr

LocalDate.parse( 
    "January 08, 2017" , 
    DateTimeFormatter.ofPattern( "MMMM dd, uuuu" , Locale.US ) 
).format( DateTimeFormatter.BASIC_ISO_DATE ) 

Using java.time

The Question and other Answers use troublesome old date-time classes, now legacy, supplanted by the java.time classes.

You have date-only values, so use a date-only class. The LocalDate class represents a date-only value without time-of-day and without time zone.

String input = "January 08, 2017";
Locale l = Locale.US ;
DateTimeFormatter f = DateTimeFormatter.ofPattern( "MMMM dd, uuuu" , l );
LocalDate ld = LocalDate.parse( input , f );

Your desired output format is defined by the ISO 8601 standard. For a date-only value, the “expanded” format is YYYY-MM-DD such as 2017-01-08 and the “basic” format that minimizes the use of delimiters is YYYYMMDD such as 20170108.

I strongly suggest using the expanded format for readability. But if you insist on the basic format, that formatter is predefined as a constant on the DateTimeFormatter class named BASIC_ISO_DATE.

String output = ld.format( DateTimeFormatter.BASIC_ISO_DATE );

See this code run live at IdeOne.com.

ld.toString(): 2017-01-08

output: 20170108


About java.time

The java.time framework is built into Java 8 and later. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat.

To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310.

The Joda-Time project, now in maintenance mode, advises migration to the java.time classes.

You may exchange java.time objects directly with your database. Use a JDBC driver compliant with JDBC 4.2 or later. No need for strings, no need for java.sql.* classes. Hibernate 5 & JPA 2.2 support java.time.

Where to obtain the java.time classes?

  • Java SE 8, Java SE 9, Java SE 10, Java SE 11, and later - Part of the standard Java API with a bundled implementation.
    • Java 9 brought some minor features and fixes.
  • Java SE 6 and Java SE 7
    • Most of the java.time functionality is back-ported to Java 6 & 7 in ThreeTen-Backport.
  • Android
    • Later versions of Android (26+) bundle implementations of the java.time classes.
    • For earlier Android (<26), the process of API desugaring brings a subset of the java.time functionality not originally built into Android.
      • If the desugaring does not offer what you need, the ThreeTenABP project adapts ThreeTen-Backport (mentioned above) to Android. See How to use ThreeTenABP….

🌐
IT Tools
it-tools.tech › date-converter
Date-time converter
Collection of handy online tools for developers, with great UX. IT Tools is a free and open-source collection of handy online tools for developers & people working in IT.
🌐
YouTube
youtube.com › mike thomas
Excel: How To Quickly Convert Text Dates to Real Dates Without Using Formulas (Text-to-Columns) - YouTube
In this video tutorial you'll learn how to efficiently convert text-based dates into actual, usable date formats in Excel, all without the need for complex f...
Published   May 12, 2024
Views   404
🌐
Quest Blog
blog.quest.com › home › various ways to use the sql convert date function
SQL CONVERT date formats and functions
April 26, 2024 - DECLARE @InputDate DATETIME = '2020-12-08 15:58:17.643' SELECT 'd' AS [FormatCode], 'Short Date Pattern' AS 'Pattern', Format(@InputDate, 'd') AS 'Output' UNION ALL SELECT 'D' AS [FormatCode], 'Long Date Pattern' AS 'Pattern', Format(@InputDate, 'D') AS 'Output' UNION ALL SELECT 'f' AS [FormatCode], 'Full Date/Time pattern (Short Time)' AS 'Pattern', Format(@InputDate, 'f') AS 'Output' UNION ALL SELECT 'F' AS [FormatCode], 'Full Date/Time pattern (Long Time)' AS 'Pattern', Format(@InputDate, 'F') UNION ALL SELECT 'g' AS [FormatCode], 'General Date/Time pattern (Short Time)' AS 'Pattern', Forma
🌐
ArcGIS Pro
pro.arcgis.com › en › pro-app › latest › help › mapping › time › convert-string-or-numeric-time-values-into-data-format.htm
Convert string or numeric time values into date format—ArcGIS Pro | Documentation
If you have time values stored in a string or numeric (short, long, float, or double) field, you can convert them into a date field type using the Convert Temporal Field geoprocessing tool. Use this tool to specify a standard or custom time format for interpreting date and time values and converting those into one of the date formats.
🌐
Iers
datacenter.iers.org › dateConverter › date_converter.php
Date Converter
To convert a date choose the input format and enter your data.
🌐
Microsoft Support
support.microsoft.com › en-us › office › convert-dates-stored-as-text-to-dates-8df7663e-98e6-4295-96e4-32a67ec0a680
Convert dates stored as text to dates - Microsoft Support
You can use the DATEVALUE function to convert most other types of text dates to dates. If you import data into Excel from another source, or if you enter dates with two-digit years into cells that were previously formatted as text, you may see a small green triangle in the upper-left corner ...
🌐
Adverity
docs.adverity.com › reference › 2-enrich › python-expressions-for-managing-dates › converting-dates-from-one-format-in-to-another.html
Converting dates from one format to another — Adverity Documentation documentation
For example, if the dates to convert are in the format DD-MM-YYYY, then the date format to enter into Python expression is '%d-%m-%Y'. The date formats of '%d/%m/%Y' or '%d.%m.%Y' would fail because the characters between the date placeholders are wrong.
🌐
Mirth Community
forums.mirthproject.io › home › mirth connect › support
Convert Date to specific format - Mirth Community
January 9, 2014 - tmp.ns::['ddtBirthdate'] = DateUtil.convertDate(msg['PID']['PID.7']['PID.7.1'].toString(), 'yyyyMMdd', 'yyyy-MM-ddTHH:mm:ss', "DATE VAR"); ... the first parameter is the inbound mask, in your case: yyyyMMdd the seccond is the outbound mask, in other words your expected date format: yyyy-MM-ddTHH:mm:ss the last parameter is the variable that has the value in according of your inbound mask, for you: msg['PID']['PID.7']['PID.7.1'].toString() So:
🌐
dbt Community
discourse.getdbt.com › help
How to convert different date formats to unique date format - Help - dbt Community Forum
August 10, 2024 - Hi All, We are exporting data from our ERP system into a CSV file, but we noticed that the date format has changed to (1/31/2022, 1/1/2022, 31/7/2023) and is stored in the table as a STRING type after processing. How can we convert these dates into a consistent format, specifically YYYY-MM-DD ...