convert to yyyymm

[Anonymous]

hi,

how can ı convert DATE to YYYYMMDD format?

like to function in SQL >> to_char(date,'yyyymm')

thanks.

[Anonymous]

date(date#(date,'YYYYMMDD'),'YYYYMM')

[sunilkumarqv]

Hi Hopes this helps

Date(Date#(DateField,'MM/DD/YY'),'YYYYMMDD ')

[#4 · Accepted solution]

Try this: Text(Date(YourDateField,'YYYYMMDD'))

[#5]

The expression convert your date field in a string

[Anonymous]

thanks this is more general expression.