INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Create a custom date field  (Read 2611 times)

AndromAK

  • Regular Member
  • Junior Woodchuck
  • **
  • Posts: 77
  • Omnes Vulnerant, Ultima Necat
Create a custom date field
« 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
Logged

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: Create a custom date field
« Reply #1 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.
Logged

AndromAK

  • Regular Member
  • Junior Woodchuck
  • **
  • Posts: 77
  • Omnes Vulnerant, Ultima Necat
Re: Create a custom date field
« Reply #2 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]
Logged

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: Create a custom date field
« Reply #3 on: March 12, 2011, 06:16:07 pm »

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

AndromAK

  • Regular Member
  • Junior Woodchuck
  • **
  • Posts: 77
  • Omnes Vulnerant, Ultima Necat
Re: Create a custom date field
« Reply #4 on: March 13, 2011, 04:53:19 am »

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
Logged

rick.ca

  • Citizen of the Universe
  • *****
  • Posts: 3729
Re: Create a custom date field
« Reply #5 on: March 13, 2011, 11:45:50 am »

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

Works fine for me.
Logged
Pages: [1]   Go Up