INTERACT FORUM

More => Old Versions => Media Center 15 (Development Ended) => Topic started by: AndromAK on March 12, 2011, 12:06:19 pm

Title: Create a custom date field
Post by: AndromAK on March 12, 2011, 12:06:19 pm

hello  all.

I searched the forum but didn't found what i want to do:

I want to use MC to archive pictures I found on the net, and i want to trace the date i downloaded them.
I don't want to use default fields as [Date Imported] or [Date recorded] or [Date Modified] , but want to use a custom field with the same type of data.

for example, I would like to use the expression:

FormatDate([Date Downloaded,0],yyyy//MM//dd - dddd)   where [Date Downloaded] is my custom date field

I would like to use this custom date field as any other date field, as [Date], [Date Imported], etc...

I tried to create a custom field with User Data->String, User Data->Integer or User Data->Decimal, and then copy the default [Date] field to test, but it didn't work...

Is it possible with MC15?

Thanks for your help

Title: Re: Create a custom date field
Post by: rick.ca on March 12, 2011, 04:18:15 pm

Quote

Is it possible with MC15?

No, but a date data type for custom fields has been added to MC16.

Title: Re: Create a custom date field
Post by: AndromAK on March 12, 2011, 05:42:26 pm

Yes! I just discovered this new data type in MC16.

To copy , for example the [Date] field in a [Custom Date] field created as "User data/Data type/Date" in MC 16,
we have to first:
- create a custom field [Date RAWDATA] / Calculed data / Expression : "[Date, 0]"
- then Copy field / [Date RAWDATA] -> [Custom Date]

Title: Re: Create a custom date field
Post by: rick.ca on March 12, 2011, 06:16:07 pm

Why not just Rename [Custom Date] using "=[Date]" or Copy field [Date] to [Custom Date]?

Title: Re: Create a custom date field
Post by: AndromAK on March 13, 2011, 04:53:19 am

Quote from: rick.ca on March 12, 2011, 06:16:07 pm

Why not just Rename [Custom Date] using "=[Date]" or Copy field [Date] to [Custom Date]?

Just Copying [Date] to [Custom Date] doesn't work.
Using a temporary field with expression [Date, 0] is necessary to access the raw data.
Then, copying this temporary field to the custom one works

Title: Re: Create a custom date field
Post by: rick.ca on March 13, 2011, 11:45:50 am

Quote

Just Copying [Date] to [Custom Date] doesn't work.

Works fine for me.