Date format validation in SAP Datasphere

[Balu22]

Hi Team,

please help me to validate Date format which is coming from source table or file  in SAP Datasphere.

Thanks,

Bala

[bheemeshRao]

Hi Bala,

[bheemeshRao]

Hi Balu, if this suffice your requirement https://community.sap.com/t5/technology-q-a/determine-if-valid-date-via-sql/qaq-p/9506869

[bheemeshRao]

Hi Balu,

could you please let us know what exactly you are trying to achieve?

Are you trying to bring in data to datasphere via a replication flow? where do you want to validate the date?

[Balu22]

Hi Bheemesh,

I would like to validate Date format in Dataflow but I don't see any inbuilt function to validate Date format.

I want to validate Date format coming from source table or File whether it is matching with Business requirements.

Example:  Date should come as 'YYYY-MM-DD'

Is there any inbuilt function to validate or any python script to validate Date Format.

Thanks,

Balu