Jun 11, 2003 #1 zaq888 MIS Jun 2, 2003 46 MY How can i convert 5/6/2003 to 6 MAY 2003 format? I'm Keep Studying.... please show the way... Not Good in English
How can i convert 5/6/2003 to 6 MAY 2003 format? I'm Keep Studying.... please show the way... Not Good in English
Jun 11, 2003 #2 PS42 Technical User Jun 4, 2003 52 AU Hi zaq888 Use the Format command eg .. To print "5/6/2003" as 5 June 2003, use Code: Format(DateField,"d mmmm yyyy") Look up the format command and masking in the MSDN doco for more information on what is possible with this command. Upvote 0 Downvote
Hi zaq888 Use the Format command eg .. To print "5/6/2003" as 5 June 2003, use Code: Format(DateField,"d mmmm yyyy") Look up the format command and masking in the MSDN doco for more information on what is possible with this command.
Jun 11, 2003 #3 tsh73 Programmer Apr 27, 2002 304 RU zaq888, you can try format("5/3/2003","Medium date" or format("5/3/2003","dd mmm yyyy" Upvote 0 Downvote
zaq888, you can try format("5/3/2003","Medium date" or format("5/3/2003","dd mmm yyyy"
Jun 11, 2003 Thread starter #4 zaq888 MIS Jun 2, 2003 46 MY thanks ps42, thats the best way I'm Keep Studying.... please show the way... Not Good in English Upvote 0 Downvote