Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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