Requesting help in converting 2018-09-01 date format to 20180901 date format

[Manjari]

Requesting help in converting 2018-09-01 date format to 20180901 date datatype

I tried the following but not getting the desired output:

1. DateTimeparse, output-> 2018-09-01 in date datatype 

2. DateTimeFormat, output->20180901 in string data type 

I want 20180901 in date data type. 

Any sugesstions

[BenMoss · Accepted solution]

This is not possible.

With all true databases date format is always YYYY-MM-DD and this is why you can only have dates in this format as a datetimediield.

If you want to mask the formatting for a report then your only option is to convert to a string which in this case could be done with a replace...

Replace([field],"-","")

B3n