Conversion of Date & Time format
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
RanjanKT
8 - Asteroid
‎07-30-2019
08:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Can some one help me to convert the Below Date(MMDDYYYY HHMM) field to (YYYY-MM-DD) format.
I have tried using the DateTimeParse([AnticipatedWinDate], "%Y-%m-%d") formula, But some how i am getting the error saying.
"ConvError: Formula (14): DATETIMEPARSE: Cannot convert "Oct 30 201" to a date/time with format "%YY-%m-%d": Expected a number for year: 'Oct 30 201'":
The format is as below.
Labels:
- Labels:
- Date Time
10 REPLIES 10
razoux1970
6 - Meteoroid
‎02-05-2023
01:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your string field (i.e. CREATE_DATE1) might have hidden characters. Did you try adding the Data Cleansing tool into your workflow? I had the same issue and it worked for me

- « Previous
-
- 1
- 2
- Next »