Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Fixed length date field
- Thread starter rechless
- Start date
Hi rechless
Assuming the data you are working with is a Date (or DateTime) field, you could convert it to text using the following:
If the data is a text field, post an example of the existing format.
Hope this helps.
Cheers
Pete
Assuming the data you are working with is a Date (or DateTime) field, you could convert it to text using the following:
Code:
ToText({Table.Date}, 'yyyyMMdd')If the data is a text field, post an example of the existing format.
Hope this helps.
Cheers
Pete
- Status
Similar threads
- Locked
- Question
- Locked
- Question