how to set date format in eval asp.net

Question

Hello

this is my date eval <%#Eval("Date", "{0:dd/MMM/yyyy}")%> when i convert to excel i want excel filter to be look like this so what to change my eval so that it can look like as below

Answer 1

Hi @RAVI，

date eval <%#Eval("Date", "{0:dd/MMM/yyyy}")%>

If you want the date to be displayed in a format like "18-Feb-25", you need to set the format to dd-MMM-yy.

1. dd : The day of the month, from 01 to 31.
2. MMM : The abbreviated name of the month.
3. yy : The year, from 00 to 99.

In data bind, it should look like:

 <%# Eval("Date", "{0:dd-MMM-yy}") %>

For more details about the date and time format, please refer to this doc: https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

Best regards,

Xudong Peng

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.