Eyal
-
Posts
3 -
Joined
-
Last visited
Everything posted by Eyal
-
You are right - and if you want a YYYYMMDD format than this is the calculated field you need (just figured it out) Year(Date) & If(Length(Month(Date)) =1, "0" & Month(Date), Month(Date)) & If(Length(Day(Date)) =1, "0" & Day(Date), Day(Date))
-
Hi Phil, Thanks for the reply. I need two different formats because one field ("3 January 06") is then exported for listings in a magazine and the other ("20060103") will be used for an online listings database. So i need one field which is easy to read, and one which SQL will understand.
-
Please help: i have thousands of records with a formatted date field. I need to duplicate this field and its content for all records and then change the date format of the new fields, so i have two date fields with the same date values, but in different formats. After that, all entered date in the first fields should automatically appear in the new date field with the new format. Is this possible? Thanks.