APPLYING DATE FORMAT

mkpjsr · **Posted:** Mon Apr 30, 2012 1:42 pm

hi experts

i want to display date in this format 02-APR-12 .plz guide me how can i do this?

mohana_cse06 · **Posted:** Mon Apr 30, 2012 2:02 pm

Try something like

Code: Select all

FORMAT(<yourdatefield>,0,'<Day,2>-<Month Text,3>-<Year>')

mkpjsr · **Posted:** Tue May 01, 2012 8:03 am

hi experts

i want to display date in this format 02-APR-12 .plz guide me how can i do this?

mohana_cse06 · **Posted:** Tue May 01, 2012 8:09 am

mohana_cse06 wrote:

Try something like

Code: Select all

FORMAT(<yourdatefield>,0,'<Day,2>-<Month Text,3>-<Year>')

What about this? :roll:

mibuso.com