Weird date glitch

[giametti]

I'm having a problem with date fields sometimes being passed in a parameter in a strange non-date format. It may appear in the field as 1/11/14, but is passed in the parameter as 11.01.2014. Data in this format can't be put into a date field in a script, and GetAsDate returns a question mark.

I can't figure out what's going on. This glitch is somewhat inconsistent. 

Jim

[comment]

The way date appears in a field is not necessarily the way it is stored. Moreover, "1/11/14" is not a valid date, but "11.01.2014" could be - depending on the date format being used by the file.

 

You should start by examining what's stored in the source date field: in Layout mode, format the field to display the date "As entered" and examine your real data. Next, enter Find mode and search for any invalid date entries (use a ? as the criteria). Also check what is the file's date format in use, for example by clicking into a date field (set to display "As entered") and inserting the current date from the Insert menu.