Conversion of Date & Time format
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- 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:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @RanjanKT
DateTimeParse wants you to specify the format that the data is currently in, not what you want it output like
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @RanjanKT if you use the datetime tool and following format it should work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the response.
encountering the below error.
ConvError: Formula (14): DATETIMEPARSE: Cannot convert "Oct 30 201" to a date/time with format "%b %d %Y": Year number is out of range 1400..9999: '201'
and the dated are appearing "Oct 30 201"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the response.
For some reason i am getting the below error.
ConvError: DateTime (25): DateTime_Out: Cannot convert "Oct 30 201" to a date/time with format "%m/%d/%Y %H:%M:%S": Expected a number for Month: 'Oct 30 201' Record #5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
i have tried both the possibilities. But the Out put is reflecting null. and the existing field format is changing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I can't explain why the left 11 positions of that date are only reading 10 bytes. If there are junk characters in the data would be my only guess.
Cheers,
Mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, i'm facing similar problem - can't convert m/d/yyyy format.
Any ideas as to what the problem is will be very appreciated!
Thanks!
