current month on default value

[romio]

how can i show the name of the current month, using the default value, I use day(now()) and year(now()).

I tried using month(now()) and monthname(now()) but they don’t seem to be working! any help?

Thanks

 

[FoFa]

Try: FORMAT(now(),"mmm")
You can return a fully formated date say 03-JAN-2005 like:
FORMAT(now(),"dd-mmm-yyyy")

 

[romio]

Thanks a lot FoFa.