topic Re: Variables - Convert Date to Numeric Value in App Development

Variables - Convert Date to Numeric Value

jerryr125 — Sat, 08 Aug 2020 08:37:37 GMT

Hi - I have the following variable:

vForecastDateStart

=date(today(),'MM/DD/YYYY')

I would like to convert it to a numeric value such as YYYYMMDD

I tried this :

vForecastDateStartNumeric:

num(left(Date($(vForecastDateStart),'MM/DD/YYYY'),4)&left(right(Date($(vForecastDateStart),'MM/DD/YYY'),4),2)&right(Date($(vForecastDateStart),'MM/DD/YYY'),2))

No luck - any thoughts ? thanks - Jerry

Re: Variables - Convert Date to Numeric Value

rubenmarin — Sat, 08 Aug 2020 09:40:08 GMT

Hi, with simple quotes for variable value it should work, also you need to change the date format:

num(left(Date('$(vForecastDateStart)','YYYYMMDD'),4)&left(right(Date('$(vForecastDateStart)','YYYYMMDD'),4),2)&right(Date('$(vForecastDateStart)','YYYYMMDD'),2))

Or just:

=Num#(Date('$(vForecastDateStart)','YYYYMMDD'),'0')

Re: Variables - Convert Date to Numeric Value

PrashantSangle — Sat, 08 Aug 2020 11:13:28 GMT

date(Today(),'YYYYMMDD')

num#(date(today(),'YYYYMMDD'))

Regards,

Prashant Sangle

Re: Variables - Convert Date to Numeric Value

Vegar — Sun, 09 Aug 2020 01:04:53 GMT

Do you want to present it as Date with format YYYYMMDD or do you want to store it as the number YYYMMDD?

If date with format then your got the answer from earlier repliers.

If number then you would need to wrap text(), num(text()) or evaluate (text()) around it.

Like this

Num( Text( Date( date#('$(v Forecast DateStart)', 'MM/DD/YYYY'), 'YYYYMMDD')))

Re: Variables - Convert Date to Numeric Value

johngouws — Sun, 09 Aug 2020 02:36:27 GMT

Hi Jerry,

I think Date# will do it.

Date(Date#($(vForecastDateStart),'YYYY-MM-DD'),'YYYY/MM/DD')

Re: Variables - Convert Date to Numeric Value

Usama — Sun, 09 Aug 2020 08:53:02 GMT

Hi,

You can try this:

=Num#(Date('$(vForecastDateStart)','YYYYMMDD'),'0')

Thanks,

Usama

Re: Variables - Convert Date to Numeric Value

jerryr125 — Sun, 09 Aug 2020 11:52:19 GMT

perfect ! Thank you !