how to convert date to text

Hi there I was wondering how do you convert 2/3/2020 (which is a date format) to 2/3/2020 ( a text format)

Accepted answers

Hey - Can you try the below replacing "Date Format" with your date formatted line item:

TEXT(MONTH(DATE FORMAT)) & "/" & TEXT(DAY(DATE FORMAT)) & "/" & TEXT(YEAR(DATE FORMAT))

Thanks.

Hey - Can you try the below replacing "Date Format" with your date formatted line item:

TEXT(MONTH(DATE FORMAT)) & "/" & TEXT(DAY(DATE FORMAT)) & "/" & TEXT(YEAR(DATE FORMAT))

Thanks.

Just thought it would be relevant to share this idea;

Would make this process a lot easier!

Best,

Callum

@CallumW I upvoted that!

Surprisingly, @jnoone suggestion is not even mentioned on the data conversion Anapedia page.

I can't tell you how often I have to make this conversion.

@Jmanaplanner46 just make sure you make that conversion in a system module. Calculate once, reuse often...

I have upvoted this too!

I agree that how many times we need to do this.

It would simply things if we have a direct solution to this.

Cheers,

Yash

Almost similar to @jnoone approach, if it is required for the date and month to be in 2 digits, I usually convert the date to number using formula

YEAR(DATE FORMAT) * 10000 + MONTH(DATE FORMAT) * 100 + DAY(DATE FORMAT), and then convert it to text format using TEXT and MID functions.

Regards,

Andre

Try using the Name(Date Line item), it will return as text.

@rishi8118 Date line item is a Date format and NAME() will convert an list item or list format Line Item to text.

How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…