How to copy date from date/time field to another date field (on form)?

jas101
Tera Expert

‎07-24-2018 04:59 AM

Hi guys, on our change form what is the best way for us to populate field 'CAB date' (a date field) with the date from the 'Meeting start time' (a date/time field) that is selected by our user on a custom field 'CAB meeting' (which references table 'Cab meeting') - see below of screenshot of CAB meeting look-up example.

So we want to take the date from 'Meeting start time' and populate our 'CAB date' field with this.

Many thanks.

find_real_file.png

 

Preview file
43 KB
0 Helpfuls
  • 2,963 Views
16 REPLIES 16

jas101
Tera Expert
In response to Michael Ritchie

‎07-26-2018 06:49 AM

Thanks Michael, the key bit of info there was that I didn't realise the info would always be stored in the 'regular system format of YYYY-MM-DD HH:MM:SS' - I guess I thought it would be in what you have set your system date format to.

Yeah I'm wondering whether maybe setting it on a business rule is a better idea, could then hide the field until it is populated I guess (so users won't wonder why it isn't on the form before saving).

0 Helpfuls

Kush Sharma
Tera Guru
In response to Jaspal Singh

‎08-19-2019 02:55 AM

Hey Jaspal,

I have two date fields and requirement is , if the date is not same in both the fields then it should populate error.

Can you please help?

Thanks

0 Helpfuls