Date with sum nums

[pgalvezt]

Hello,

I would to show my date with sum nums in date format, like

[Fecha Inicio] +0 as SumDATEPRUEBA,

[Fecha Inicio] +1 as SumDATEPRUEBA1, and so on....

Num#([Fecha Inicio],'YYYYMMDD') as SumDATEPRUEBA2 (This bring the same I think in text Format)

[sunny_talwar]

How about this:

Date([Fecha Inicio],'YYYYMMDD') as SumDATEPRUEBA2

[sunny_talwar]

Or this:

Num([Fecha Inicio]) as SumDATEPRUEBA2

or

Num#(Date([Fecha Inicio],'YYYYMMDD'), '##') as SumDATEPRUEBA2

[pgalvezt]

Hi Sunny,

I put:

Num#(Date([Fecha Inicio],'YYYY-MM-DD'), '##') +1 as SumDATEPRUEBA2, But fiel is turn null

Changed YYYYMMDD for YYYY-MM-DD because the format is that.

[sunny_talwar]

How about this:

Num#(Date([Fecha Inicio] + 1,'YYYY-MM-DD'), '##') as SumDATEPRUEBA2

[pgalvezt]

Is reading as text because the date is in the left. Everyting else is ok.

[sunny_talwar]

Can you try this:

Num#(Date([Fecha Inicio] + 1,'YYYYMMDD'), '##') as SumDATEPRUEBA2

[sunny_talwar]

Lets actually take a step back. What exactly do you want?

Input               Output?

14-12-2015     20151412 (Number Formated or Date Formatted)

[pgalvezt]

Input               Output?

14-12-2015     15-12-2015

Fecha Inicio +1 

[sunny_talwar · Accepted solution]

Try this:

Date(Date#([Fecha Inicio], 'DD-MM-YYYY') + 1,'DD-MM-YYYY') as SumDATEPRUEBA2

or if the date is read properly, then this:

Date([Fecha Inicio] + 1,'DD-MM-YYYY') as SumDATEPRUEBA2