Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have a full date with DD/MM/YYYY hh:mm format. But i'd like to know how to split it to get DD/MM/YYYY format. Vizlib calendar only accept DD/MM/YYYY format
cdt
Hi,
you can easily just create a new data field from the existing one:
ex.
New_Data_field_name = Date( Old_data_field_name, 'DD/MM/YYYY' )
Old_data_field_name would correspond to the field with the full date with DD/MM/YYYY hh:mm format
You can as well create this field in the Loading script:
Date( "Old_data_field_name", 'DD/MM/YYYY' ) as New_Data_field_name
Hi,
you can easily just create a new data field from the existing one:
ex.
New_Data_field_name = Date( Old_data_field_name, 'DD/MM/YYYY' )
Old_data_field_name would correspond to the field with the full date with DD/MM/YYYY hh:mm format
You can as well create this field in the Loading script:
Date( "Old_data_field_name", 'DD/MM/YYYY' ) as New_Data_field_name