AnsweredAssumed Answered

Filemaker Date format

Question asked by eekamouse on Feb 3, 2009
Latest reply on Sep 28, 2009 by aematt

Title

Filemaker Date format

Post

is there any method of automatically inserting a date so that it is actually entered (not displayed) as mm/dd/yyyy

 

I need to ultimately export a date in the following format yymmdd manipulated by a calculation based on a date field (where the date is actually entered)

 

using the Insert Current Date step inserts m/d/yyyy which becomes problematic when the months and days become two digits instead of 1

 

I need the month to be consistantly entered as 01 for January as opposed to 1 and same for the day or I  need a complicated case of nested if statement

 

Any ideas

 

sweating bullets

Outcomes