Date formatting

[#1]

I am reading a date from a file.  It comes in as 'May 6, 2014'.  I want to convert it to the numeric format (such as 41051, et al), but cannot seem to get the syntax right.  All I can get it to do is simply show it as it already is...even using the 'Date#' function.

[its_anandrjs]

Did you try my suggestion is this wrong

Num(Date#('May 6, 2014','MMM D, YYYY'))

Or

Num(date#(YourDateField,'MMM D, YYYY')) as NewField