
Creator II
2018-12-17
06:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date convertion to DD/MM/YYYY format
Hi Experts,
Can any one please help me to convert the below Date field into DD/MM/YYYY format it contains the MM/DD/YYYY and number format records like below.
Thanks in advance
12,018 Views
1 Solution
Accepted Solutions

MVP
2018-12-17
07:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this
Date(Alt(Num(Date), Num(Date#(Date, 'M/D/YYYY'))), 'DD/MM/YYYY') as Date
4 Replies


Master III
2018-12-17
06:09 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try like this
Date(Datte_field,DD/MM/YYYY) as date
11,974 Views

Master
2018-12-17
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
date#(date(dt,'MM/DD/YYYY'),'MM/DD/YYYY')
try above method
try above method
11,962 Views

Master
2018-12-17
06:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
date#(date#(date(date(num(dt),'MM/DD/YYYY'),'DD/MM/YYYY'),'DD/MM/YYYY'),'DD/MM/YYYY')
11,951 Views

MVP
2018-12-17
07:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this
Date(Alt(Num(Date), Num(Date#(Date, 'M/D/YYYY'))), 'DD/MM/YYYY') as Date
